Given two tables stored on HIVE

party $($contains party$\_$name, consituency$\_$name$)$

constituency$($consituency$\_$name, improvement$\_$description, year, date$)-$ logs every

improvement made in a constituency

We need to find out the total number of improvements made by different political parties in a

For example, how many improvements did ModernParty make in $2018.($i$)$ design a

HIVE SQL query to achieve this objective$($exact syntax is not neessary. Important to get the

logic right$).($ii$)$ illustrate through a DAG, how HIVE will translate this query through a series

of Map Reduce steps to execute this query.