Give names of manufacturers and their cities that are located in cities with names ending with 'City'. Give all the data for sales from January 21 of 2015 through the end of the month. (Use BETWEEN) List the information of each sale item where 2 or more items were sold but only for sizes 5, 6, and 7 (Use the keyword IN.) Show all sale item information.
Give all the data for sales from January 21 of 2015 through the end of the month. (Use BETWEEN)
List the information of each sale item where 2 or more items were sold but only for sizes 5, 6, and 7 (Use the keyword IN.) Show all sale item information.
Give date and the sum of tax and shipping for each sale from December 20th through December 25th of 2015. (use BETWEEN. Name the calculated column SUM)
Create an alphabetical list of names (first and last, alphabetized by last) of customers in Minnesota.
What is the customerID for Sam Gill?
What are the sales dates and shipping amount of sales with over $55 of shipping charges?
List the data in the Salaried Employees table about Salaried Employees earning between $40000 and $50000. (use between)
Give full names of customers that have a 'D' as the third character in their last names. Eliminate duplicates.
Give names of manufacturers and their cities that are located in cities with names starting with 'C'.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
