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

Solution:

SELECT CONCAT(last_name, first_name) as underclass_volunteers, grad_year FROM volunteer INNER JOIN volunteer_hours ON volunteer.xnumber= volunteer_hour.volunteer_xnumber WHERE volunterr_date= '2020' AND volunteer_date= '2021' ORDER BY grad_year DESC, last_name ASC, first_name DESC.

The above query will do the job for you, here CONCAT is used to concatenate two columns into one named as "underclass_volunteers".

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it.

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

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