mysql基本语句三个简单考试问题!求助! 5C

图片说明

不太会(b)和(c)的后面两个
去年的考试题 复习用 希望大神给我指点迷津
谢谢

3个回答

(c)
(I)select driverID,name
from driver
where age>35
(II)select driverID,count(driver)
from driver,rental
where driver.driverID=rental.driver
group by driverID

select driverID,max(year(date))
from driver,rental
where driver.driverID=rental.driver
group by driverID

(b)
select count(registrationNumber),model
from car,rental
where car.registrationNumber=rental.registration
and
date='2015-01-06'
group by model

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐