An energy company is analyzing electricity usage. Instead of comparing today’s consumption to yesterday’s, they want to compare it to the same day one week earlier. How can this be achieved with LAG? OPTIONS:A. Use LAG with a partitionB. Use LAG with an offset of 7C. Use LEAD with an offset of 7D. Use GROUP BY week instead of day ANSWER:B EXPLANATION:Adding an offset parameter to LAG allows comparisons several rows back (e.g., LAG(value, 7) for a 7-day lookback).

A hospital tracks patient wait times in the emergency department. Times are partitioned by day of the week and ordered by arrival time. If the hospital uses NTH_VALUE(wait_time, 3), what does the returned value represent? A) The third-longest wait time on that day B) The average of the first three wait times on that day C) The wait time of the third patient to arrive on that day D) The last patient’s wait time on that day Correct Answer: The wait time of the third patient to arrive on that day Explanation:Nth value returns the specified position within the ordered window. Since the data is ordered by arrival time, the third value corresponds to the third patient who arrived that day. It does not mean the third-longest time, an average, or the last patient’s wait time.

A logistics company wants to calculate each driver’s average delivery time compared to the overall company average. Why are window functions a good choice here? OPTIONS:A. They permanently store averages in the databaseB. They allow calculations across related rows without reducing the datasetC. They are faster than all other SQL approachesD. They eliminate the need for any joins ANSWER:B EXPLANATION:Window functions allow calculations across groups (like averages by driver or company-wide) while keeping all rows visible. They don’t permanently store values (A), don’t always guarantee faster performance (C), and don’t eliminate the need for joins (D).

An HR analyst writes the following query to analyze salaries: SELECT department, employee_name, salary, SUM(salary) OVER (PARTITION BY department) AS dept_total FROM employees; What does the dept_total column represent? OPTIONS:A. The total salary across the entire companyB. The salary of the highest-paid employee in each departmentC. The total salary for the department shown on each rowD. The cumulative salary ordered by employee name ANSWER:C EXPLANATION:The SUM OVER (PARTITION BY department) calculates the total salary within each department, repeated on each employee’s row.

What is red tide?

What was the treatment for Cora’s Creutzfeldt-Jakob disease in Chapter 1’s Clinical Focus?

What does polyphyletic mean? Which group of eukaryotes is polyphyletic?

Name a type of cell division most common for prokaryotes and a type of cell division common for eukaryotes.

What is the most common nematode infection in the US?

Match the supergroup with its unique characteristic.