1.SELECT fName,lName FROM conductor order by fname;.
2 Pages275 Words475 Views
Added on 2019-09-16
1.SELECT fName,lName FROM conductor order by fname;.
Added on 2019-09-16
BookmarkShareRelated Documents
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;
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Concepts Question Answer 2022lg...
|14
|1624
|54
SQL statements for data manipulation and database testing on Employees databaselg...
|19
|1637
|351
Entity Relationship Modelling Assignmentlg...
|17
|2659
|240
Proof of Testing SQL Queries Query 1 SELECT `memberName`,lg...