★ Must-know
To find users missing from the latest report, select users whose UserID is not in the report having the maximum ReportDate.
To find currently active users, select UserID and UserName from Users where UserStatus equals 'Active'.
To find users with a specific role, select UserID, UserName and UserRole where UserRole is in 'Administrator', 'Manager' or 'Analyst'.
Further detail
To find users who joined in the current year, select users where YEAR(JoinDate) equals YEAR(CURDATE()).
To find users without an assigned department, select users where DepartmentID IS NULL.
To find users with a salary greater than 50000, select UserID, UserName and Salary where Salary > 50000.
Filter by report, status, role, year, department, then salary
★ Must-know
📐 Formula — The dose delivered during a 4-to-7-minute session is calculated as , so the dose per session is 11.11 Gy.
Further detail
1. Which SQL condition identifies users who are missing from the most recent report?
2. Which SQL query condition finds users who are currently active?
3. Which SQL filter finds users whose role is Administrator, Manager, or Analyst?
How to find users missing from the latest report in SQL?
Select users whose UserID is not in the report with the maximum ReportDate.
How to find currently active users in SQL?
Select UserID and UserName from Users where UserStatus equals 'Active'.
How to find users with specific roles in SQL?
Select UserID, UserName and UserRole where UserRole is in 'Administrator', 'Manager' or 'Analyst'.
How to find users who joined in the current year in SQL?
Select users where YEAR(JoinDate) equals YEAR(CURDATE()).
How to find users without an assigned department in SQL?
Select users where DepartmentID IS NULL.
How to find users with salary greater than 50000 in SQL?
Select UserID, UserName and Salary where Salary > 50000.
It covers the core concepts of SQL Queries, Dosimetry and Rational Numbers, organized by topic with the key definitions, explanations and takeaways, so it's easier to learn and remember.
Read the full study guide →The practice quiz has 13 multiple-choice questions, each with an explanation. Use it to check what you know and find your gaps.
Take the quiz (13 questions) →There are 26 flashcards on SQL Queries, Dosimetry and Rational Numbers, with a question on the front and the answer on the back. Try to recall each answer before you flip, and let spaced repetition bring back the ones you miss.
See all 26 flashcards →Upload a PDF or paste your notes. Revizly writes a study guide, a practice quiz and flashcards in about a minute.