Query 1- Write an SQL query that shows the CustomerID, EmployeeID, and SaleDate

Question

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

Query 2- Write an 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-Write an SQL query that shows all customer information for customers in the cities – Redmond, Bellevue or Seattle.

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

Explanation / Answer

As, you have not provided with the schema I have given the answer as it was understood by looking at the questions. Thankyou

1. SELECT CUSTOMER_ID, EMPLOYEE_ID, SALE_DATE WHERE SALE_DATE = 1/1/2014 AND SALE_DATE > 1/1/2014;

2. SELECT ITEM_ID, ITEM_DESCRIPTION, PURCHASE_DATE WHERE COST >= 500 AND VENDOR_ID = 9;

3. SELECT CUSTOMER_ID,CUSTOMER_NAME,CITY WHERE CITY = 'REDMOND' OR CITY = 'BELLEVUE' OR CITY = 'SEATTLE';

4. SELECT ITEM_ID, ITEM_DESCRIPTION WHERE COST >=500 OR COST <= 1000;

Do upvote....Thankyou

Hope this helps...

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.