Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning ASP.NET 4.5 Databases

Authors: Sandeep Chanda, Damien Foggon

3rd Edition

1430243805, 978-1430243809

More Books

Students also viewed these Databases questions

Question

What is the most important part of any HCM Project Map and why?

Answered: 1 week ago