题目内容
Consider the employee database:employee (ID, person_name, street, city)works (person_name, company_name, salary)company (company_name, city)Give an expression in SQL to express each of the following queries :1) Find the name of each employee who lives in city “Qingdao".2) Find the name of each employee whose salary is greater than $100000.3) Find the name of each employee who lives in “Qingdao" and whose salary is greater than $100000.4) Find the ID and name of each employee who works for "Tencent" .5) Find the ID and name of each employee who does not works for "Tencent".6) Find the ID, name, and city of residence of each employee who works for "Tencent".7) Find the ID, name, street address, and city of residence of each employee who works for "Tencent" and earns more than $ 10000.8) Find the ID and name of each employee in this database who lives in the same city as the company for which she or he works.
查看答案
搜索结果不匹配?点我反馈