2. Write a SQL query to solve Question-2-2 (the second sub-question). 3. Write a SQL query to solve Question-2-3 (the third sub-question). 4. Write a SQL query to find the name of oldest sailors for each rating level. 5. Find the average age of sailors for each rating level that has at least two sailor 6. Write a SQL query to find the average number boats reserved by different sail 7. Write a SQL query to find the names of sailors who reserved all non-blue boa 8. Write a SQL query to find the name of the boat that is most popular one. 9. What does the following two queries do? SELECT sid SELECT sid FROM s WHERE rating > all ( SELECT rating FROM s s2 FROM s WHERE rating> any ( SELECT rating FROM s s2 WHERE s2.sname='Bob’)) WHERE s2.sname='Bob’)

2. Write a SQL query to solve Question-2-2 (the second sub-question). 3. Write a SQL query to solve Question-2-3 (the third sub-question). 4. Write a SQL query to find the name of oldest sailors for each rating level. 5. Find the average age of sailors for each rating level that has at least two sailor 6. Write a SQL query to find the average number boats reserved by different sail 7. Write a SQL query to find the names of sailors who reserved all non-blue boa 8. Write a SQL query to find the name of the boat that is most popular one. 9. What does the following two queries do? SELECT sid SELECT sid FROM s WHERE rating > all ( SELECT rating FROM s s2 FROM s WHERE rating> any ( SELECT rating FROM s s2 WHERE s2.sname='Bob’)) WHERE s2.sname='Bob’)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Describe how any company's information systems use databases.
Explain how a company uses a database in its information systems, using any company as an example.
Find out how online databases may be used for many purposes such as the government, entertainment, travel, commerce, research, and educational purposes.
Explain how an organization uses databases in its information systems, preferably using a specific organization as an example.
Explain how an organization utilizes databases in its information systems, particularly with reference to a specific organization.
Impact on privacy and security of data mining
It's not safe to put your personal information into a database. How often, if ever, are you allowed to request and get hard copies of your data records from each database? Concerned about protecting your privacy while online?
Differentiate between database management systems and file-oriented systems.
Explain the concept of spatial data types in a database system. Provide examples of applications where spatial data types are crucial.
Differentiate between database management systems and file-oriented systems.
large scale database
Explain the concept of distributed databases and their advantages. Provide examples of situations where distributed databases are preferred over centralized databases.