Where can a CTE that yields a table of one column and several rows be utilized?

You want to show the total cargo weight shipped by each ship. Which query gives each ship name and the total cargo weight it carried?

What is a valid reason for implementing a one-to-one relationship using shared primary keys?

What is the order of precedence for Boolean operators in SQL?

Which SQL clause is specifically used to group rows for aggregation functions like SUM or COUNT?

In a relational database, data are stored in:

What must be true of a column or column combination before it can serve as a primary key in SQL?

What does the asterisk (*) symbolize when it is used right after SELECT?

You want to create a list of ship names and their destination ports for voyages that went to ‘Singapore’. You use a CTE to define the voyages first. Which query gives the correct result?

Given table SHIP, write an SQL query to find the ship types that have an minimum length less than 200, along with the count of ships for those types.