Create sql query that shows the itemid itemdescription and


Query 1- Create SQL query that shows the CustomerID, EmployeeID, and SaleDate for all sales made on and after 1/1/2014

Query 2- Create SQL query that shows the ItemID, ItemDescription and PurchaseDate for Items that have an item cost of $500 and above and supplied by VendorID 9.

Query 3-Create SQL query that shows all customer information for customers in the cities - Redmond, Bellevue or Seattle.

Query 4-Create SQL query that shows ItemID and ItemDescription for items that have an item cost between $500 and $1000.

Query 5-Create SQL query that shows the SaleId and the total ItemPrice for each sales ID in the SALE_ITEM table

Query 6-Create SQL subquery that shows the CustomerLastname, CustomerFirstname, Email for customers who have made a SALE Subtotal of $10,000 and above..

Query 7-Create SQL query that shows the EmployeeID, EmployeeLastName, EmployeeFirstname, Employee Phone, CustomerId, SaleDate and Total. Please ensure to have the results sorted in ascending order by Employee Lastname

Solution Preview :

Prepared by a verified Expert
Business Management: Create sql query that shows the itemid itemdescription and
Reference No:- TGS02491313

Now Priced at $35 (50% Discount)

Recommended (91%)

Rated (4.3/5)