Blog

Consider the below query:   SELECT StudentName,CASEWHEN Grade > 60 THEN ‘D’WHEN Grade > 70 THEN ‘C’WHEN Grade > 80 THEN ‘B’WHEN Grade > 90 THEN ‘A’ELSE ‘F’END AS LetterGradeFROM Students;   What would the output be on a value of 91?

A company has a table called Employees with the columns: EmployeeIDEmployeeNameDivision Which query will count the number of employees in each division and return only the divisions that have at least 1000 employees?

Consider the below table.   The query   SELECT * FROM Songs2 WHERE Duration < 235    Would return how many results?  

Which of the below is used for multi line comments in SQL?

Consider the below table.   Which query would select songs with a null duration?

A company has a table called Employees with the columns: EmployeeIDEmployeeNameDivisionSalary Which query will return each division and its highest salary, but only include divisions where the highest salary is less than $100,000?

A tavern tracks its beer sales in a table called Beers with the columns: BeerNameCategory (values: Craft, Domestic, Imported)QuantitySold Which query will return the total quantity sold for each beer category?

Consider the below table.   SELECT Avg(Coalesce(Duration,0)) FROM Songs would return what value?  Round to 2 decimals if needed.

Electron transport chain is located in:

ATP synthase is best described as: