Part $3$: The optimizer makes the wrong decisions

Create a database with data sets already loaded into tables. Come up with five queries where the query

optimizer made the wrong decision. To prove the wrong decision, you need to use query hints and$/$or

enforce the XML plan of other query plans and record the estimated cost for the optimizer$$s generated

query plan and execution time for your enforced query plan. The enforced query plan that was not

chosen by the query optimizer MUST perform better than the one chosen by the query optimizer