$3.$ QueriesThe queries listed below are those that you have to find. Wenow call these query categories as TYPE. $($total $12$ differencequery types$)-($TYPE$1)$ Find address of homes for sale in the districtMapo. $(1)-($TYPE $1-1)$ Then find the costing between $1,000,000,000$ and $1,500,000,000.(2)$DATABASE SYSTEM PROJECT $3-($TYPE $2)$ Find the address of homes for sale in the $8$thschool district. $(3)-($TYPE $2-1)$ Then find properties with $4$ or morebedrooms and $2$ bathrooms. $(4)-($TYPE $3)$ Find the name of the agent who has sold themost properties in the year $2022$ by total won value. $(5)-($TYPE $3-1)$ Then find the top k agents in the year$2023$ by total won value. $(6)-($TYPE $3-2)$ And then find the bottom $10\%$ agents inthe year $2021$ by total won value. $(7)-($TYPE $4)$ For each agent, compute the average sellingprice of properties sold in $2022,$ and the average time theproperty was on the market. $(8)-($TYPE $4-1)$ Then compute the maximum sellingprice of properties sold in $2023$ for each agent. $(9)-($TYPE $4-2)$ And then compute the longest time theproperty was on the market for each agent. $(10)-($TYPE $5)$ Show photos of the most expensive studio,one$-$bedroom, multi$-$bedroom apartment$($s$),$ anddetached house$($s$),$ respectively, from the database. $(11)-($TYPE $6)$ Record the sale of a property that had beenlisted as being available. This entails storing the salesprice, the buyer, the selling agent, the buyers agent$($ifany$),$ and the date. $(12)$