Ask a question to Desklib · AI bot
1.SELECT fName,lName FROM conductor order by fname;.
Added on -2019-09-16
| 2 pages
| 275 words
| 475 views
Trusted by 2+ million users,
1000+ happy students everyday
1.SELECT fName,lName FROM conductor order by fname;2. SELECT concert.title, concert.date, concert.ticketPrice, conductor.fnameFROM concert inner join conductor on concert.conductorEmployeeId=conductor.conductorEmployeeId;3. SELECT consertMusician.instrumentId, instrument.instrumentName fromconsertMusician inner join instrument on consertMusician.instrumentId=instrument.instrumentId group by consertMusician.instrumentId order by count(consertMusician.instrumentId)desc limit 1;4. SELECT fName, lName FROM conductor WHERE conductorEmployeeId NOT IN (SELECT musicianEmployeeId FROM consertMusician);5. SELECT conductor.fName, conductor.lName FROM concert inner join consertMusician on concert.conductorEmployeeId=consertMusician.musicianEmployeeId and concert.concertId=consertMusician.consertId inner join conductor on concert.conductorEmployeeId=conductor.conductorEmployeeId;6. SELECT instrument.instrumentName, count(employee.employeeID) as countEmployee from employee inner join instrument on employee.instrumentId=instrument.instrumentId group by employee.instrumentId;7, CREATE VIEW allData AS SELECT AVG(concert.ticketPrice) as avgTicketPrice, COUNT(consertMusician.musicianEmployeeId) as countConcert, musician.fName, musician.lName FROM consertMusician inner join concert on consertMusician.consertId=concert.concertId inner join musician on consertMusician.musicianEmployeeId=musician.musicianEmployeeId GROUP BY consertMusician.musicianEmployeeId HAVING countConcert > 1;
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan