(Solved): Please write a SQL query for the question below: 4. Advertising System Failures Report As p ...

Please write a SQL query for the question below:

4. Advertising System Failures Report As part of HackerAd's advertising system analytics, a team needs a list of customers who have a maximum number of fallure events (status = "failure") in their campaigns. For all customers with more than 3 events with status = 'failure', report the customer name and their number of failures: The result should be in the following format: customer, fallures. - customer is a candidate's full name, the firstiname and lastiname separated by a single space - The order of the output is not important. T Sample Data Tables For the sample data in tables: customers id first_name last_name For the sample data in tables: id first_name last_name \begin{tabular}{|l|l|l|} \hline 1 & Whitney & Ferrero \\ \hline \hline 2 & Dickie & Romera \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline id customer_id & name \\ \hline & 1 & Upton Group \\ \hline 2 & 1 & Roob, Hudson and Rippin \\ \hline 3 & 1 & McCullough, Rempel and Larson \\ \hline 4 & 1 & Lang and Sons \\ \hline 5 & 2 & Ruecker, Hand and Haley \\ \hline \end{tabular} \begin{tabular}{c|c|c|} \hline dt & cvents \\ \hline campaign_id status \end{tabular}