Question: 1. Given the table: CUSTOMER(CustID, Name, PhoneNumber, AccountBalance) Write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins
1. Given the table: CUSTOMER(CustID, Name, PhoneNumber, AccountBalance) Write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S 2. You have two tables named SalesInvoice and SalesInvoiceDetails. CustomerID is located in the SalesInvoice table and InvoicelD is located in both tables. You have been told to show the discount amounts from the SalesInvoice Detail table that correspond to the sales of a specific CustomerID of 490 Write the SQL query to that would return this result You have a table named - Sales [employeeID, firstName, last Name, Hired, title] You want to see all the full names of your sales people Hired after 2018/01/01' listed in alphabetical order. The result set must be sorted by the concatenated field. Write the SQL query to that would return this result 3. You have two tables - Customer and SalesInvoice. You need a report of all invoice numbers that have an InvoicelD of over 500. Each invoice should be listed each time that it was a customer that placed an order. The report should show the first name and last name of the customer who placed the order. This report should be sorted alphabetically by ProductName and lists all dates each product was ordered. Write the SQL query to that would return this result 5. You have two tables - Customers and Orders Not all customers have placed an order yet. You would like to see a list of customers and the total number of orders listed next to the CustomerlD Write the SQL query to that would return this result
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
