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.

You want to see the number of voyages each ship has taken. Each result should show the ship’s name and how many voyages are listed in SHIP_VOYAGE. Which query works?

What does the BETWEEN operator do in a SQL query?

Given table SHIP, write an SQL query using the SHIP table to retrieve the unique ship owner_names present in the table.

What is the primary role of an associative entity in a relational schema?

If you learn one implementation of SQL, what does that mean for learning others?

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?

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

Given table SHIP, write an SQL query to retrieve the ship names and types for ships that have a hull number of ‘A123’ or ‘BR549’.

Which of the following statements about the WHERE clause is correct?