Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now

Task 6 (3 marks)Write an SQL Statement that displays all the details of rooms. Display only rooms from ‘B1′ and’B4’, If the capacity of a room is not between 120 (exclusive) and 160 (exclusive). Capacity mustbe displayed, not just with the value but with the text ‘PEOPLE’ appended to it with a space (E.g.’60 PEOPLE’). Use proper aliases for any computational columns.Task 7 (3 marks)Write an SQL Statement that displays the details (id, date and price) of sessions. Display sessionsthat are scheduled on June, 2017 or cost $14 or less. Price must be prefixed with “$” and theresults must be sorted by the date of the sessions, in descending order.Task 8 (4 marks)5 ISYS114 Assignment-2, 2017Write an SQL statement that displays the details of sessions (id and date) that are scheduled if thespeaker’s phone number has ‘03’ as the area code. You MUST use equi-join to obtain the answerTask 9 (4 marks)Rewrite Task 8 without a join and use a sub query insteadTask 10 (4 marks)Write an SQL statement that displays the details of sessions (id, buildingno and roomno) that arescheduled in rooms that are not in ‘B2’ with at least 180 seating capacity. You MUST use a join toobtain the answer. The result must not include duplicate valuesTask 11 (4 marks)Write an SQL Statement that displays all the details of sessions. Display sessions that schedule aspeaker who has a name with letter ‘A’ as the third character or have fewer than 7 characters intheir name. Your result should also include the names of speakers displayed in lowercase.Task 12 (4 marks)Write an SQL Statement to find the number of sessions scheduled in each room in every building.Display the room details (building number and room number) and their corresponding numberof sessions. Perform a multi-level sort with building number and the number of sessions. You donot have to include rooms that have not been scheduled yet.Task 13 (6 marks)Write an SQL Statement that displays only the top 2 buildings and their corresponding averageprice of a session. (The top 2 buildings are those which have the highest average costs).Task 14 (5 marks)Write an SQL Statement that displays the details of sessions – id, wing of the building the sessionis scheduled for, the name of the speaker, room capacity and the session date. Include only thesessions scheduled on 6th of June, 2017 or 13th of May, 2017.Task 15 (6 marks)Write an SQL Statement that displays the details of sessions (id, total price). If a session getscompletely booked out, include only those sessions that would make over $5000. Sort the resultsin descending order. [Session getting booked out, means every seat in the rostered room has beenpaid for/booked]

Task 6 (3 marks)Write an SQL Statement that displays all the details of rooms. Display only rooms from ‘B1′ and’B4’, If the capacity of a room is not between 120 (exclusive) and 160 (exclusive). Capacity mustbe displayed, not just with the value but with the text ‘PEOPLE’ appended to it with a space (E.g.’60 PEOPLE’). Use proper aliases for any computational columns.Task 7 (3 marks)Write an SQL Statement that displays the details (id, date and price) of sessions. Display sessionsthat are scheduled on June, 2017 or cost $14 or less. Price must be prefixed with “$” and theresults must be sorted by the date of the sessions, in descending order.Task 8 (4 marks)5 ISYS114 Assignment-2, 2017Write an SQL statement that displays the details of sessions (id and date) that are scheduled if thespeaker’s phone number has ‘03’ as the area code. You MUST use equi-join to obtain the answerTask 9 (4 marks)Rewrite Task 8 without a join and use a sub query insteadTask 10 (4 marks)Write an SQL statement that displays the details of sessions (id, buildingno and roomno) that arescheduled in rooms that are not in ‘B2’ with at least 180 seating capacity. You MUST use a join toobtain the answer. The result must not include duplicate valuesTask 11 (4 marks)Write an SQL Statement that displays all the details of sessions. Display sessions that schedule aspeaker who has a name with letter ‘A’ as the third character or have fewer than 7 characters intheir name. Your result should also include the names of speakers displayed in lowercase.Task 12 (4 marks)Write an SQL Statement to find the number of sessions scheduled in each room in every building.Display the room details (building number and room number) and their corresponding numberof sessions. Perform a multi-level sort with building number and the number of sessions. You donot have to include rooms that have not been scheduled yet.Task 13 (6 marks)Write an SQL Statement that displays only the top 2 buildings and their corresponding averageprice of a session. (The top 2 buildings are those which have the highest average costs).Task 14 (5 marks)Write an SQL Statement that displays the details of sessions – id, wing of the building the sessionis scheduled for, the name of the speaker, room capacity and the session date. Include only thesessions scheduled on 6th of June, 2017 or 13th of May, 2017.Task 15 (6 marks)Write an SQL Statement that displays the details of sessions (id, total price). If a session getscompletely booked out, include only those sessions that would make over $5000. Sort the resultsin descending order. [Session getting booked out, means every seat in the rostered room has beenpaid for/booked]

Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now