SALESREPSalesRepNo654734345434RepNameJonesSmithChenJohnsonHireDate01/02/200502/03/200701/25/200411/23/2004CUSTOMERCustNo9870859078404870CustNameWinstonGonzalesHarrisMilesBalance500350800100SalesRepNo345434654345 c) Write the standard SQL query to retrieve the Name and PhoneNumber of customers whose name begins with'S'.d) Write the standard SQL query to retrieve the average customer balance grouped by SalesRepNo

like is used when you want to fetch records based on some patterns like starting with some letter ,…

Answered: Write the standard SQL query to…

Write the standard SQL query to retrieve the Name and PhoneNumber of customers whose name beg 'S'. Write the standard SQL query to retrieve the average customer balance grouped by SalesRepNo

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: What did each card cost? Show the card number, player last name, team name, price, price with 5%…

Q: Just let me know what to write for the SQL theory: Question: Write a query to display the first…

A: Solution: Given,

Q: in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: MarketPoint Sales currently has a credit limit of $5,000. Because MarketPoint Sales has an excellent…

A: Yes, the given statement is true.

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: How does the RANK() function differ from DENSE_RANK() in SQL when ranking data?

A: Data ranking in SQL is accomplished using both the RANK() and DENSE_RANK() methods. They are…

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: Create the following table in your database with the following schema: Table: Products Column Name 1…

A: As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…

Q: Based on this design, write a query in SQL to display the book's title, the publisher's name, the…

A: Introduction: A query is used to fetch the data from the database or table. The syntax to fetch the…

Q: Based on the picture please write an SQL theory for the following (DONT ANSWER THE ACTUAL QUESTION):…

A: The SQL queries for 3 questions are given below Join is being used...

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Write an SQL Query that will show the following attributes from theORDERS table: ORDER #, CUSTOMER…

A: “ORDER BY” Clause: SQL contains "ORDER BY” clause in order to sort rows. The values get sorted in…

Q: Write a SQL query. List names of all employees who have sold to customer Rachel Patterson (Note: You…

A: In this database problem, we are tasked with creating an SQL query that lists the names of all…

Q: Create a PL/SQL query to display the combined customer name, coin purchased, coin price andthe…

A: THE GIVEN SQL QUERRY FOR THE QUESTION

Q: Write an SQL query to find all customers whose name (either last name or first name) contains…

A: The following SQL queries can be used to achieve various tasks related to data searching and…

Q: Using your credit card information to transfer money online comes with a number of risks that you…

A: Given: Overspending: For people who cannot control their need to spend money, a credit card may be a…

Q: Write a SQL Query that uses the annual growth to get a projection for total population for the years…

A: Given tables are: table_1: CountryName, Year, AnnualGrowth, CumulativeGrowth table_2:CountryName,…

Q: Write an SQL query that will show all data from the Customers table andOrder By State.

A: SQL query: Query to select all the data from the “Customers” table order by “State” SELECT * FROM…

Q: Create the following tables in your database with the following schema: Table: Countries | Column…

A: As per our guidelines, only 3 sub parts will be answered. So, please repost the remaining questions…

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

SALESREP
SalesRepNo
654
734
345
434
RepName
Jones
Smith
Chen
Johnson
HireDate
01/02/2005
02/03/2007
01/25/2004
11/23/2004
CUSTOMER
CustNo
9870
8590
7840
4870
CustName
Winston
Gonzales
Harris
Miles
Balance
500
350
800
100
SalesRepNo
345
434
654
345

c) Write the standard SQL query to retrieve the Name and PhoneNumber of customers whose name begins with
'S'.
d) Write the standard SQL query to retrieve the average customer balance grouped by SalesRepNo

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

How do you compose a subquery in SQL where you are searching for the most common value in one column for a specific value from another column (i.e. looking for the down where most penalties occur --> down is a column and PlayType is a column with penalties as a value). The columns are in the same table.
How do I do this question in SQL command? Use the Oracle database employees table and CASE expression to decode the departmentid. Display the department id, last name, salary, and a column called “New Salary” whose value is based on the following conditions: If the department id is 10 then 1.25 * salary If the department id is 90 then 1.5 * salaryIf the department id is 130 then 1.75 * salary Otherwise, display the old salary.
Consider the following table: Instructors ID 12121 15151 22222 32343 33456 name Alice Wu John Mozart Frank Einstein El Said Chelsea Dunn deptName Finances Music Physics History Physics salary 90000.00 40000.00 95000.00 60000.00 90000.00 Write a single SQL query to list in descending order the deptNames and names of all instructors. Note that every column of Instructors should be included in the result.
, Write the following queries using SQL: List details of all customers from Canberra that have enrolled in a course order by Customer Number. How many customers from Canberra have enrolled in a course conducted by an instructor with Instructor Number = 12345? List the number of male staff in each section. List the first and last name of all female staff that have made an appointment with a customer from Canberra for repair work. What is the average salary of male staff from Canberra?
I need help on this problem: Write an SQL query that displays the therapies and their unit of time for the therapies that include the word bath, hot, or electrical.
I need help with the SQL query for the following question: 1. What is the total number of reviews in every zip code. Here is the information on the field names: The table name is: Reviews Review Form Fields Product/ModelName: Product/Category: Product/Price: Retailer/Name: Retailer/ZipCode: Retailer/City: Retailer/State: Product/On Sale: Manufacturer/Name: Manufacturer/Rebate: Review/UserId: Review/Rating: Review/Date: Review/Text: Example of Review Form Filled out ProductModelName: Galaxy S4 ProductCategory: Smart Phone ProductPrice: 499 RetailerName: Bestbuy RetailerZipCode: 44114 RetailerCity: Cleveland RetailerState: OH ProductOnSale: No ManufacturerName: Samsung ManufacturerRebate: No ReviewUserId: xmm473 ReviewRating: 3 ReviewDate: 6/10/2012 ReviewText: overheats after 2 hours
Write a function named product that takes two int parameters and returns the product of those two integers. Here is an example: int n = product(7, 5); // n is 35 We are providing a test framework that, if you wish, you may use with a compiler to test your function. What you will submit as your answer to this problem is only the product function. Do not submit things like the #include lines or a main routine. If we take the code you write in the space below and insert it into the program, the resulting program must build without compilation errors (mere warnings are allowed). You do not need to write comments in the code; we will not look at any comments. Here is the test framework that you may copy and paste into a C++ source file. For your own testing purposes, you might add additional tests in the main routine, although you won't be turning them in, of course. #include <iostream> #include <cassert> using namespace std; // SUBMIT AS YOUR ANSWER ONLY THE CODE BETWEEN THIS…