Plays and Reservations SQL

You are given two tables describing theater plays and reservations for these plays in specific theaters.

create table plays (
id integer not null,
title varchar(40) not null,
writer varchar(40) not null,
unique(id)
);

create table reservations (
id integer not null,
play_id integer not null,
number_of_tickets integer not null,
theater varchar(40) not null,
unique(id)
);

Write an SQL query that counts the total number of tickets reserved for each play. The table of results should contain three columns: id (id of play), title (title of play), and reserved_tickets (total number of reserved tickets for play). Rows should be ordered by decreasing reserved_tickets. In the case of a tie, rows should be sorted by increasing id of play.

Examples:

1. Given:

plays:

reservations:

The query should return:

2. Given:

plays:

reservations:

your query should return: