Making SQL queries
$10-30 USD
Pagado a la entrega
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?
Nº del proyecto: #18354330
Sobre el proyecto
Adjudicado a:
9 freelancers están ofertando un promedio de $37 por este trabajo
Hello there, I can do and finish this. Lets discuss more. Thanks...................................................
Hi, I performed database related jobs (SQL) as explained below. - Cognos Project - Oracle Financials (Oracle EBS) Project - Oracle Transportation Management (OTM) Project - Siber Logistics Software Project Más
Hello I can help you in this right away I am a master of SQl and can help you nicely Send me a message Thanks
We have read your project description and will surely develop a modern project for your business as per your specifications. In the past year we have developed 50+ sites for business like your requirement.
Hey bro ,I will help you out for your problem. I’m experienced in sql and database administration. Thankyou
1) 2 year + experience in MySQL back end programming. 2) Lots of work done on procedures, functions, views, triggers. 3) Maintained 1000+ tables in the database. with above 50000 records n particular table.
