数据库的题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：数据库

长期有效，类似作业有很多200-5000/次

可以直接加我，欢迎咨询V:NOV11251640

欢迎和大神长期合作

顶顶顶顶顶顶顶顶顶顶

顶顶顶顶

顶顶顶顶顶顶顶顶顶顶

供参考

a.
ActorID is Actor primary key,
PlayID is Play primary key,
ActorID , PlayId is Role Foreign Keys

b.
select a.Name from Actor a left join Role b on a.ActorID=b.ActorID
where b.Character='Elektra'

c.
select a.Name , count(c.Title) as PlayNumbers  from Actor a left join Role b on a.ActorID=b.ActorID
left join Play c on b.PlayID=c.PlayID
where a.YearBorn=1978

d.
select c.Title  from Actor a left join Role b on a.ActorID=b.ActorID
left join Play c on b.PlayID=c.PlayID
where b.Character in ('Juliet','Tybalt')

e.
select a.Name,c.Title  from Actor a left join Role b on a.ActorID=b.ActorID
left join Play c on b.PlayID=c.PlayID
group by a.Name,c.Title
having count(b.Character)>1

foxpaul 发表于 2021-12-27 09:56
供参考

a.