Blog

In the context of a table STUDENTGRADE, with columns StudentID (character) and Exam1 (numeric), why is the following SQL statement problematic: SELECT StudentID, Exam1 FROM STUDENTGRADE WHERE Exam1 > AVG(Exam1);

What are CTEs or common table expressions in SQL?

Calculate the molar mass of potassium chloride, KCl. ( K = 39.10 g/mol, Cl = 35.45 g/mol)

What does the IN operator do in a SQL query?

Why might a designer choose to define a composite primary key in a table?

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?