company id VARCHAR(2) foreign-language id INT (11) ]volunteerT t snumber VARCHAR

Question

company id VARCHAR(2) foreign-language id INT (11) ]volunteerT t snumber VARCHAR(6) last_name VARCHAR(30) barracks VARCHAR(15) VARCHAR( 15) Olang_Tame VARONR(15) Indexes first,name VARCHAR(30) sex VARO (6) date-of-birth DATE grad-year YEAR(4) major_d INT(11) major P id INT (11) title VARCHAR(45) department VARCHAR(45) offershonors TINYINT(1) Ind volunteer_knows.foreign_language t volunteer_xnumber VAROHAR (6) ? foreign_language_id INT(11) proficiency VARCHAR(45) company id VARCHAR(2) exes volunteer hours volunteer_xnumber VAROHAR(6) volunteer_date DATE organization VARCHAR(45) num.hours INT(11) Indexes

Explanation / Answer

1. Identify tables that are relevant (e.g. Volunteer, Comapny)

2. Identify which fields are to be displayed from what table (e.g SELECT id, baracks, tac from Company)

3. Add a where condition (eg SELECT id from Company where id not in (SELECT distince company_id from Volunteer)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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