Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spomenik Monument Database

Authors: Donald Niebyl, FUEL, Damon Murray, Stephen Sorrell

1st Edition

0995745536, 978-0995745537

More Books

Students also viewed these Databases questions

Question

Explain the meaning of ergonomics.

Answered: 1 week ago