a$)$ Using the classicmodels database, create a view for each scenario below to include the following SQL commands

i$.$ JOIN, BETWEEN

ii$.$ GROUP BY$,$ JOIN

iii. Wildcard Characters, ORDER BY$,$ JOIN

iv$.$ IN$,$ ORDER BY

v$.$ HAVING, GROUP BY

NB: You can include more SQL Commands. Ensure to include the ones mentioned above.