Query 1- Write an SQL query that shows the CustomerID, EmployeeID, and SaleDate
ID: 3599500 • Letter: Q
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...