Blog

Given table SHIP, write an SQL query that selects the ship name, type, and length of all ships whose length is between 300 and 400, inclusive. Additionally, sort the results by length from most to least.

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?

What does the BETWEEN operator do in a SQL query?

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

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

What is a primary reason for employing a Common Table Expression (CTE) in SQL?

Why might a database designer create an artificial attribute as a key?

In which situation should you use GROUP BY instead of DISTINCT in a SELECT query?

What does COUNT(*) return when used in a SELECT statement without a WHERE clause?

When you have a complex SQL query that involves several steps, what is the recommended approach to solve it?