What are the two major components of sql

Assignment Help PL-SQL Programming

Reference no: EM13781021

1. Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses?

FROM
WHERE
GROUP BY
HAVING
SELECT
ORDER BY

2. List the 5 aggregate functions and explain their use.

3. SQL exercises

Hotels Schema

Hotel
hotelNo hotelName city

Room
roomNo hotelNo type price

Booking
hotelNo guestNo dateFrom dateTo roomNo

Guest
guestNo guestName guestAddress

Use the hotel schema above to write SQL statements for the following queries.

a. List full details of all hotels.

b. List full details of all hotels in London.

c. List the names and addresses of all guests in London, alphabetically ordered by name.

d. List all double or family rooms with a price below £40.00 per night, in ascending order of price.

e. List the bookings for which no dateTo has been specified.

4. What are the two major components of SQL and what function do they serve?

Reference no: EM13781021

Questions Cloud

Main types of sociology of sports theories : Submit a paper, in APA format, that addresses the "dedicated to sports" phenomenon. Applying each of the main types of sociology of sports theories (cultural theories, interactionist theories, and structural theories), answer the question: "Why ar..

Competency based individualized strategies for supporting : Use the definition laid out in IDEA to describe Michael's hearing disorder and the competency based individualized strategies for supporting him in a school setting.

Regarding the projct user interface : Prepare a detailed design document for the user interface for your project. Your design document should be based on your Project Requirements and Scope document and your Project Design proposal.

Provide feedback on business proposal : Provide feedback on Business proposal. Include detailed, substantive comments.

What are the two major components of sql : Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses. What are the two major components of SQL and what function do they serve

Conduct a risk assessment of a town : Conduct a risk assessment of a town, state, or country other than your own, and create a strategic mitigation, response, and recovery plan for presentation before the emergency planning board of your community.

The value of critical thinking : Give your opinion on whether being an effective critical thinker makes decision making easier or more challenging. Justify your response. Consider the following statement: "The major difference between a successful person and one that is not succe..

Eliminate the problem of adverse selection : How does the employer mandate help eliminate the problem of adverse selection? Would a single-payer plan, in which everybody is insured through the government, further reduce the problem of adverse selection?

Write ananalysis essay on hunger games : Write ananalysis Essay on hunger games.

User Account

All Pages