SQL Queries, Dosimetry and Rational Numbers

📋 Course Outline

1. User Search Queries in SQL
2. Patient Dosimetry Calculations
3. GCD, LCM and Powers
4. Fractions and Simplification
5. Rational Number Objectives

📖 1. User Search Queries in SQL

★ 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.

💡 Memory Hook

Filter by report, status, role, year, department, then salary

📖 2. Patient Dosimetry Calculations

★ Must-know

• The mean dose of the whole lesion is 55.6 Gy.

📐 Formula — The dose delivered during a 4-to-7-minute session is calculated as $5.556 \times 2 = 11.11\ \text{Gy}$, so the dose per session is 11.11 Gy.

Further detail