Please solve question 12 , SQL , SQL management 2009-2014

Hi From Ben Morning From ab hi Question 12 From Good Not yet answered The following query is executing very slowly on a large amount of data, Would an Index help to speed it up? If so, which columns should be indexed? Explain why an index can help but doesn't always Marked out of 10.00 ever P Flag question Edit question SELECT c.cinetta_nate, s.price"SUM(t.ticket_id) AS 'total' FROM Cinema C INNER JOIN MovieSessions on c.cinema_id - S.cinema_id INNER JOIN Ticket t ON t.ticket_id - s.ticket_id GROUP BY s.price, c.cinema_name HAVING SUM(t.ticket_id) > 5 From At 1 whe Fro ye B 7 5 22 Fre t Question 13 Not yet answered The following query for a small business database is supposed to select the names and salaries of all marketing staff who ea However, is not working and retrieves 0 rows What is wrong with the query and how would you fix it? Warted out of 10.00 Pag question Hi From Ben Morning From ab hi Question 12 From Good Not yet answered The following query is executing very slowly on a large amount of data, Would an Index help to speed it up? If so, which columns should be indexed? Explain why an index can help but doesn't always Marked out of 10.00 ever P Flag question Edit question SELECT c.cinetta_nate, s.price"SUM(t.ticket_id) AS 'total' FROM Cinema C INNER JOIN MovieSessions on c.cinema_id - S.cinema_id INNER JOIN Ticket t ON t.ticket_id - s.ticket_id GROUP BY s.price, c.cinema_name HAVING SUM(t.ticket_id) > 5 From At 1 whe Fro ye B 7 5 22 Fre t Question 13 Not yet answered The following query for a small business database is supposed to select the names and salaries of all marketing staff who ea However, is not working and retrieves 0 rows What is wrong with the query and how would you fix it? Warted out of 10.00 Pag