You want to list the name of every ship followed by the name of its owner, but only for ships that have a matching owner in the OWNER table. Which query returns the correct result?

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?