Question: Using the CoffecDB database, do the following queries. JUST TURN IN QUERIES (the SQL code), NOT THE DB (table create) CODE!!!! Ensure you number each
Using the CoffecDB database, do the following queries. JUST TURN IN QUERIES (the SQL code), NOT THE DB (table create) CODE!!!! Ensure you number each one (as in)- 1. Display all records in the country table; sort by country name, Z to A 2. Display inventory description and type (only coffee or tea): sort by type. 3. Display state name, population, land area and tax rate for all states where the land area is greater than 50,000 square miles 4. Display state name and whether it has a web Site for all states that do not have a web site. 5. Display consumer first and last name, phone number and credit limit, for all consumers whose first name starts with a D (ok this is a police situation and your only clue is that letter!). Sort by last name (Z to A). Note: all persons are presumed innocent until tried in a court of law. 6. Display quantity, price, and discount (from order line table) for all records where the price is less than or equal to 15 or the discount is greater than .05. 7. Display last name, commission rate, hire date, and gender for all employees who are women who were also hired on or after Dec 15, 1995. Sort by last name. Z to A 8. Display last name, state, sredit limit and whether the consumer is favored or not, for those consumers whose credit limit is between $7500 and S10000 or who are not favored consumers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
