Anyone Who Can Hack This Asap For $25
blank87
sqlbh.docxIS 312 SQL Bonus Homework
Dr. Yue “Jeff” Zhang, February 18, 2019
Due Wed/Thur for MW/TR classes, respectively
Problem 1A – for students with last name A~G
List Restaurant ID, City, State, Annual sales, and Square footage, for those restaurants in Florida, with annual sales not more than $350,000 and square footage not more than 2000. No sorting needed.
2 points
Problem 1B – for students with last name H~P
List Restaurant ID, City, State, Annual sales, and Square footage, for those restaurants in Northridge, with annual sales at least $700,000 and square footage at least 2000. No sorting needed.
Problem 1C – for students with last name Q~Z
List Restaurant ID, City, State, Annual sales, and Square footage, for those restaurants in Miami, with annual sales at least $500,000 and square footage below 2000. No sorting needed.
Problem 2A – for students with last name A~G
4 points
List Restaurant ID, City, State, Annual sales, Square footage, and Type of service, for those restaurants in California, OR for those restaurants with annual sales at least $700,000 and square footage at least 2000. Sort by state first and then within the same state by type of service.
Problem 2B – for students with last name H~P
Problem 2C – for students with last name Q~Z
List Restaurant ID, City, State, Annual sales, Square footage, and Type of service, for those restaurants in Santa Monica, OR for those restaurants with square footage at least 1200 but annual sales below half a million. Sort by type of service first and then within the same type by annual sales high to low.
Please present your outputs in either one of the following formats, depending on the actual size of the output screenshot:
A table of two columns, with code or left and screenshot on right;
OR
A table of two rows, with code on top row and screenshot on bottom row.
Remember to put your name on the upper-right corner.
