Can somebody help me with this needs to be in Access please and thank you

Query$1$: A query that contains a compound condition $($more than one condition$)$ and the results are sorted by at least one of the displayed columns.

Query$2$: A query that contains a GROUP BY and one of the built$-$in functions, such as SUM, AVG, COUNT etc.

Query$3$: A query that requires the join of two $($or more$)$ tables

Query$4$: A query that has a computed$$ column $($if you create a query in

Access you need to use Builder feature in Access to create a computed expression$)$

For SQL query, an example of a computed column would be like SELECT UnitPrice $*$ Volume AS "Sales" FROM ORDER