SQL的问题，高分在线等答案，答对了再追加分

2025-02-07 22:44:53

推荐回答（4个）

回答1：

1.select au_id,au_lname,au_fname,city from authors;
2.select * from titles;
3.select au_lname,au_fname,city from authors where state='CA';
4.select * from authors where au_fname like 'A%';
5.select * from authors where au_fname like '_e%';
6.select * from authors where au_fname like '%o%' or '%e%';
7.select * from authors where au_fname like '[M^_i]%';
8.select orderID,productID,UnitPrice,quantity,sum(UnitPrice*quantity) from OrderDetails group by orderID,productID,UnitPrice,quantity;
9.没理解（要求使用+’,’+来显示结果）。
10.select customerID,contactName,contactTitle as The contactor's title is: from customers;
11.select orderID,productID,UnitPrice,quantity,sum(UnitPrice*quantity) as 总价 from OrderDetails group by orderID,productID,UnitPrice,quantity;
12.select companyName as 公司名称,contactName as 联系人,address as 地址,phone as 电话号码 from customers;
13.select productID,productName,unitprice,unitsinstock from products where unitprice between 20 and 40;

回答2：

1. select au_id,au_lname+' '+au_fname as name,city from authors
2. select * from titles
3. select au_lname+' '+au_fname as name,city from authors where state='CA'
4. select * from authors where au_fname like 'A%'
5. select * from authors where au_fname like '_e%'
6. select * from authors where au_fname like '%[oe]%'
7. select * from authors where au_fname like 'M[^i]%'
8. select orderid,productid,UnitPrice,quantity,unitPrice*quantity as PruductAmount from OrderDetails
9. select companyName,ContactName,country+','+city as city from customers
10. select companyName,ContactName,'The contactor''s title is:'+contactTitle as title from customers
11. select orderid,productid,UnitPrice,quantity,unitPrice*quantity as 总价 from OrderDetails
12. select companyname as 公司名称,ContactName as 联系人,companyAddress as 地址,companyphone as 电话 from costomers
13. select productID,productName,unitprice,unitsinstock from products where unitprice between 20 and 40

回答3：

select au_id,au_lname,au_fname,city from author
select * from title
select au_id,au_lname,au_fname,city from author where state='CA'
select * from author where au_fname like 'A%'
select * from author where au_fname like '_e%'
select * from author where au_fname like '%e' or like '%o'
select * from author where au_fname like 'M%'

回答4：

狂汗.楼上那个.不要全抄好不好...

最新问答

谁能告诉我2008~2010年上海外国语大学和北京外国语大学分数线是多少？？

下列有关燃烧和灭火的说法中，正确的是（　　） A．物质燃烧一定要有氧气（或空气） B．防火衣中的