题目内容

课本第130页第4题，要求SQL语句创建四个数据表。若要拍照上传，请写清学号姓名。

查看答案

搜索结果不匹配？点我反馈

更多问题

课本第130页第4题，要求SQL语句完成第2章习题6中的查询，先抄写题目，再写SQL语句。若要拍照上传，请写清学号姓名。

课本第130页第5题，使用SQL语句完成第（8）小题到第（11）小题的数据更新，先抄写题目，再写SQL语句；第9题，使用SQL语句创建视图，并完成查询。若要拍照上传，请写清学号姓名。

对课本第二章习题6给出的四个关系模式，请使用SQL语言完成以下查询：1）求北京市的工程项目编号；2）求供应红色零件的供应商编号和供应商名称；3）求不供应红色零件的供应商编号和供应商名称；4）求供应了全部零件的供应商编号及供应商名称；5）求为全部工程项目供应零件的供应商编号及供应商名称；6）求为北京市全部工程项目供应零件的供应商编号及供应商名称；请将SQL语句写在纸上，在纸的右上角写清学号、姓名，清晰拍照上传。

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.