J company foreign-language id INT (11) id VARCHAR(2) Hbarracks VARCHAR(15) VARCH

Question

J company foreign-language id INT (11) id VARCHAR(2) Hbarracks VARCHAR(15) VARCHAR( 15) volunteer xnumber VARCHAR(6) last name VARCHAR(30) first_name VARCHAR 30)t Olang_Tame VARAR(15) Indexes sex VAR (6) l major ? id INT (11) title VARCHAR(45) department VARCHAR(45) offershonors TINYINT(1) Indexs date ofbrth DATE grad-year YEAR(4) volunteer.knows foreign-language t volunteer_xnumber VAROHAR (6) ? foreign_language_id INT(11) proficiency VARCHAR(45) major_d INT(11) company id VARCHAR(2) volunteer hours volunteer xnumber VAROHAR(6) volunteer_date DATE organization VAROAR(45) num hours INT(11) Indexes

Explanation / Answer

select lastname as cadet,title,tac from company c,(select lastname,title,company_id from volunteer v, major m

where v.major_id=m.id and nvl(m.offers_honors,0)>0)

where company_id=c.id and order by lastname,title;

Here nvl function checks wheather it is null or not, if it is null returns 0, in this way we can check the honors value.

Related Questions

Navigate

• Browse (All)
• Browse J
• Subjects

---

---

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