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?

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

According to standard SQL execution order, which clause is processed before GROUP BY?

In SQL, what does the SELECT statement do?

Which SQL data type is most appropriate for storing fixed-length alphanumeric codes such as airport codes or postal abbreviations?

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

How is a one-to-many relationship physically represented in a relational schema?