SQL queries have to run immediately

3. Find all products that have the word “TENNIS” in their descriptions. Show ProdId and the first three letters of Descrip. (To show first three letters, you’ll need to use Substr() function. It’s discussed in the handout, Page 5. If you can’t figure out how to do it, just show ProdId and Descrip. No points will be deducted.) 4. Find all employees whose names start with either an S, A, or T whether it comes in lower case or upper case. List all information about each employee in the output. Even though this query can be done without using a function, to receive full credit, you are required to use a function. 5. Price table: the standard price (STDPrice) for product 100861 on April 1, 2006. Show this price. Use Price table. (Correct SQL should return 45 as answer.) 6. Find the current minimum price for each of these three products 100861, 100860, and 100870 in one query. (Use MinPrice column in Price table.) 7. Show a list of employees hired in April of any year. Display ename and hire date in the format as shown below. Use aliases to rename the output columns as shown. ENAME Hire Date ---------- ------------------------------- JONES Monday , April , 02, 2001. 8. What day of the week is the day that is 20 days after today? Today is the day on which the query is run, not the day on which you wrote the query. So do not enter any specific date in the query. 9. Find all customers who placed an order in January 2007. Show Custid (hint: there are three such customers.) (Use Ord table). 10. Show customerId, customer name, OrdId, and order date for each order 11. Find the total number of products sold in each year for each product