volunteerhours - volunteer_xnumber VARCHAR(6) volunteer date DATE VAR num_hours

Question

volunteerhours - volunteer_xnumber VARCHAR(6) volunteer date DATE VAR num_hours INT (11) volunteer xnumber VARCHAR(6) last_name VARCHAR(30) first_nam e VARCHAR(30) -volunteer knows-foreign-language volunteer_xnumber VARCHAR(6) +-sex VARAR(6) foreign_language_jd INT(11) proficiency VARCHAR(45) date of_birth DATE grad_year YEAR(4) major id INT(11) company_id VARCHAR(2) company foreign-language ?id INT (11) ?id VARCHAR(2) barracks VARCHAR(15) tac VARCHAR(15) lang-name VARCHAR(15) major ?id INT (11) title VARCHAR (45) departm ent VARCHAR (45) offers-honors TINYINT(1) 0

Explanation / Answer

SELECT major.department,COUNT(volunteer.xnumber) AS num_volunteers FROM volunteer
LEFT JOIN major ON volunteer.major_id = major.id
GROUP BY department
ORDER BY num_volunteers DESC, department ASC;

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.