Write SQL queries for the following problems. Show your query (in text) and the result of each query (screen image).
(10) For each consultant whose client’s average balance is less than $4,000, list the consultant number, the number of clients assigned to the consultant, and the average balance of the consultant’s clients. Rename the count of the number of clients to NumOfClients and the average of the balances to AvgBalance. Order the groups by consultant number.
(10) For every work order, list the order number, order date, client number, and client name. In addition, for each order line within the order, list the TaskID and description. Order the records by order number.
(10) Show the consultants’ names and the total quoted price for all the orders made for each consultant.
I need help writing the SQL code for this two questions

it is a requirement to graduate high school where i live

answer ingenuity;

the benefits of raising bc’s minimum wage to $15 through a

series of pre-announced staged increases far outweigh the likely

costs. claims that such an increase will lead to massive job losses

in low-wage sectors of the economy are not credible.

• an increase to $15 would result in some job losses. however,

the likely impact is less than a 1 per cent reduction in the overall

provincial employment rate, and a 7.6 per cent reduction in the

employment rate for those currently making between $10.25

and $15 per hour.

• the large job loss impacts predicted by some opponents of

minimum wages misrepresent the existing economic research. in

reading and using that research, it is important to recognize that

estimates showing job loss effects of minimum wage increases

apply only to teenagers. estimated effects for young adult and

adult workers range from insignificant to non-existent.

• focusing on teenage workers plays up an inaccurate stereotype

about who earns very low wages in bc and leads to exaggerated

claims about job losses. only 26 per cent of those currently making

between $10.25 and $12 are teenagers, and only 5 per cent

of those making between $12 and $15 are teenagers.

it is not paas i hope that