[Solved]Froducts Pro Buct Id Int Departmert Id Int Departert Name Varchar Products Product Id Int Q37228263

Froducts Pro Buct ID INT Departmert ID INT departert name VARCHAR( Products Product ID INT price VARCHAR 10) departmert size INT Fane VARCHAR( 45) Lname VARCHAR(45) dale re eed DATETIME .s1.by-date DATETIME exairatin ide DATETIME Manager Manager ID INT 1 Fname VAROHAR30) Indexes Ih dexe In dexes Trarsaction ID INT Cutner-ID VARCHAR(45) tamaction total DOUBLE paymen type VARCHAR(45》 Employees Empbyee TD INT Eeployee ID INT ornane VARCHAR(45) 1 Lname VARCHAR(45) ate VARCHAR 45) hours warked INT age INT phone number INT area code INT Transactions_has Receipts gender VARCHAR(6) Store_has_Suppliers In dexes Transaciots Empbyees Employee ID INT Recepts Recepts ID INT Indexes 1 Store Sare ID INT Suppliers Supplier JD INT Suppliers Supplier ID INT Orde ID INT Receipts suppliername VARCHAR(45 supplier cty VAROHAR(45) Price VARCHAR(20) osupplier.4ale VARCHAR(45》 In dexes Indexes List of questions Provide at least 10 meaningful questions that an end user can ask of this data. You must provide an SQL SELECT query with every question – the query that answers that question. You must have at least one of each of the following query clauses represented in your queries. Explain how the answer to the query would add value 1. Single table SELECT 2. INNER JOIN 3. LEFT JOIN 4. At least two queries using different aggregate functions (MIN, MAX, SUM, AVG, COUNT) 5. GROUP BY 6. HAVING 7. ORDER BY 8. LIMIT 9. Subquery using IN predicate Note: Don’t simply write a query for example in order to use a GROUP BY or a LIMIT. It is very important to create a meaningful question that will be answered Show transcribed image text Froducts Pro Buct ID INT Departmert ID INT departert name VARCHAR( Products Product ID INT price VARCHAR 10) departmert size INT Fane VARCHAR( 45) Lname VARCHAR(45) dale re eed DATETIME .s1.by-date DATETIME exairatin ide DATETIME Manager Manager ID INT 1 Fname VAROHAR30) Indexes Ih dexe In dexes Trarsaction ID INT Cutner-ID VARCHAR(45) tamaction total DOUBLE paymen type VARCHAR(45》 Employees Empbyee TD INT Eeployee ID INT ornane VARCHAR(45) 1 Lname VARCHAR(45) ate VARCHAR 45) hours warked INT age INT phone number INT area code INT Transactions_has Receipts gender VARCHAR(6) Store_has_Suppliers In dexes Transaciots Empbyees Employee ID INT Recepts Recepts ID INT Indexes 1 Store Sare ID INT Suppliers Supplier JD INT Suppliers Supplier ID INT Orde ID INT Receipts suppliername VARCHAR(45 supplier cty VAROHAR(45) Price VARCHAR(20) osupplier.4ale VARCHAR(45》 In dexes Indexes
List of questions Provide at least 10 meaningful questions that an end user can ask of this data. You must provide an SQL SELECT query with every question – the query that answers that question. You must have at least one of each of the following query clauses represented in your queries. Explain how the answer to the query would add value 1. Single table SELECT 2. INNER JOIN 3. LEFT JOIN 4. At least two queries using different aggregate functions (MIN, MAX, SUM, AVG, COUNT) 5. GROUP BY 6. HAVING 7. ORDER BY 8. LIMIT 9. Subquery using IN predicate Note: Don’t simply write a query for example in order to use a GROUP BY or a LIMIT. It is very important to create a meaningful question that will be answered

Expert Answer

---

Answer to Froducts Pro Buct ID INT Departmert ID INT departert name VARCHAR( Products Product ID INT price VARCHAR 10) departmert … . . .