In mysql language i nead to make these command in library system

I have the tables and elements but i dont know how to make this commands

First : make sure milestone $3$ included the following:

Milestone $3$:$(5\%)$

i$.$ Run at least $10$ advanced queries on your application including the following SQL keywords:

Union$/$Intersect$/$Difference

Distinct $,$ aggregate functions, In$,$ Between, ISNULL, NOT, LIKE

Nested queries, comparison queries $($ALL$/$ANY$),$ Group By$,$ Order By$,$ Having, INTO, Case expression, and compute clause.

ii$.$ Use DML $($Data Manipulation

Language$)$ for $($insert$/$update$/$delete$).$

iii. Create a database objects, such

as : Index, Procedure or Function, Trigger and Asseration $.$

And at least one DDL $($Data Definition Language$)$ such as Create Table.