Making SQL queries

Using MySQL #Consider a schema as follows: Supplier(SID,NAME,SUPPLIER_ZIP) Parts(PID,PNAME,PTYPE,SID) Sale(SHOPID,PID,SALES_DATE,QTY) Shop(SHOPID,SHOP_ZIP) Use VOLUME = SUM(QTY) #SUPPLIER with SID supplies this part. PTYPE can be Perishable or Imperishable. # there can be more than one SHOPID per SHOP_ZIP and more than one Supplier per Supplier_ZIP # more than one supplier can supply a PART 1. Which SHOP_ZIP sold the most volume in the year 2016? 2. Which SHOP_ZIP sold the most volume in Perishable in August 2018? 3. List all the SHOP_ZIPs that sell more Perishable than Imperishable on the first day of the month? 4. List all Suppliers that supplied more Perishable than Imperishable. 5. For each supplier_zip list the SHOP_ZIP that sold the minimum volume perishable/imperishable combined 6. Find the Part(NAME) that sold the most in 2017 7. Find the part(NAME) whose sales volume in 2016 was higher than the sales volume in 2017? 8. Approximately how many records will ittake to represent a DNA molecule if each record can hold exactl 4 nitrogen bases (A,G,C,T) 9. What base can pair with base G and base T 10. Given A SQL Statement of the form "select a,b,c from table t" and its output, can you determine the number of columns in table t?