Question: Table_Name : Column(s) Restaurants : RestaurantName, Location, Type Dishes: RestaurantName, DishName Sales: RestaurantName, DishName, SaleDate, SaleTime, Quantity, SalesPrice Given the schema above write the SQL

Table_Name : Column(s)

Restaurants : RestaurantName, Location, Type

Dishes: RestaurantName, DishName

Sales: RestaurantName, DishName, SaleDate, SaleTime, Quantity, SalesPrice

Given the schema above write the SQL to answer the following questions.

1. What are all of the Dishes that Chik-Fil-A sells?

2. How much did Subway sell from January 1st of this year to now?

3. How many restaurants are there?

4. How many dishes does each restaurant sell?

5. What restaurants sold a dish at 9 am?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

As manager of the production department, Raul is concerned about increasing direct materials costs. Last year's profit of $31,300 resulted from sales of 5,600 units at a selling price of $140. Total...

Q:

- INSERT DATA INTO TABLE - DELETE Tasks/Assignments(s) Creating Database objects by using Data Definition Language (DDL) : 1. Using the Data Definition Language statement, create new database named...

Q:

Hello, I really need help with these answers... #8 is the only one I am having a hard time with which has 3 questions please if someone can help me!?? 8. Write and Execute the commands to obtain the...

Q:

( a ) create table STUDENT ( sid number ( 7 ) , sname varchar 2 ( 3 0 ) , sdno number ( 5 ) ) ; A table named STUDENT is created in the database. Guess what is the meaning of number ( 7 ) in the...

Q:

Create the SQL statements needed to create the following tables and relationships. Please note the primary and foreign keys, nullable and non-nullable fields, and the data types. On page 253, figure...

Q:

INSERT INTO It is used to add one or more rows to a table Attribute values should be listed in the same order as the attributes were specified in the CREATE TABLE command INSERT INTO tablename...

Q:

INSERT INTO It is used to add one or more rows to a table Attribute values should be listed in the same order as the attributes were specified in the CREATE TABLE command INSERT INTO tablename...

Q:

A supermarket (like a Safeway or Lucky store) has asked your help in grouping theattributes listed at the bottom of this document into a set of relational database tables thatare all normalized to...

Q:

How are profits affected for both companies as a consequence of the sequence of decisions made by these two families. the Riojas and the Riberas? The Spanish Wine Market in New York The market for...

Q:

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

Q:

Course Project: Project 1: Language Identification and Validation Your task for Project 1 is to create a language that will allow a user to manage, store, and query user data for a corporation. You...

Q:

Refrigerant-12 in a piston/cylinder arrangement is initially at 50C, x = 1. It is then expanded in a process so that P = Cv1 to a pressure of 100 kPa. Find the final temperature and specific volume.

Q:

What do you think about Antioch Colleges no-tuition strategy? Is it sustainable for its first four years? What challenges do you see for the college?

Q:

Which account would be debited when the City of Corfu issued purchase orders for materlak and supplles? Multiple Choice Encumbrances Control. Expenditures. Expenditures Control. Budgetary Fund...

Q:

La entalp a para la reacci n de combusti n de la alanina s lida N H 2 C H ( C H 3 ) C O O H , que da los gases C O 2 y N 2 m s agua l quida es de - 1 6 2 3 k J m o l - 1 a 2 5 C . Calcula el cambio...

Q:

What is the purpose of a Position Control Table? What relationships to other Compensation Tables would be important?

Q:

What Data Elements are usually found in the Job Family Table, and what is the relationship of the Job Family Table to the Occupation Table?

Q:

What is the relationship between the Internal Staff Compensation Target Table and the Internal Staff Compensation Data Table?