sql queries for the above questions

7 20 Step 7- Join A-We need to know the name of the customers who bought computer with the model of the computer they bought. B-We also need to know the date and the price of the computers to be displayed with the name and Cusid of the customers. C-Which computers did not sold at all? Step 8- Use Scalar Functions A- Add a new sales to the sale table. Use the current date as the sale date. (Do not forget to use proper CusID and ComID) B- Find the first selling date and the last one. Find out the difference between two date values Step 9- SubQuery A- Find the lowest computer price and use it as a subquery to find the customers buying the computer with the lowest price. B- We need to know if there are customer name having 'e' or 'a' in their last names. If there are any customers by that name, find out if they bought any 'Dell computers? 7 20 Step 7- Join A-We need to know the name of the customers who bought computer with the model of the computer they bought. B-We also need to know the date and the price of the computers to be displayed with the name and Cusid of the customers. C-Which computers did not sold at all? Step 8- Use Scalar Functions A- Add a new sales to the sale table. Use the current date as the sale date. (Do not forget to use proper CusID and ComID) B- Find the first selling date and the last one. Find out the difference between two date values Step 9- SubQuery A- Find the lowest computer price and use it as a subquery to find the customers buying the computer with the lowest price. B- We need to know if there are customer name having 'e' or 'a' in their last names. If there are any customers by that name, find out if they bought any 'Dell computers