How many tables of data are there? Identify one relationship between tables - specify the field and
Fantastic news! We've Found the answer you've been seeking!
Question:
- How many tables of data are there?
- Identify one relationship between tables - specify the field and tables.
- Which employee is the oldest?
- How many customers are in London? (HINT - change country to UK)
- How many suppliers are in the US?
- What is the PRICE of Tofu?
- How many UNITS of Louisiana Hot Spiced Okra are in stock?
- What is the CategoryID for Seafood?
- Between what years do the orders take place?
- Use the ORDER BY in descending order for the data of your choice and provide a screenshot of your results. (HINT https://www.w3schools.com/sql/sql_orderby.asp) Open a browser, connect to www.w3schools.com/sql and then click the button labeled "Try it yourself."
Click the Restore Database button, and then click OK when the small dialog box appears.
You should now see a list of database tables.
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date: