$4\mathrm{.}2$ A manager at JustLee Books requested a list of all books generating a profit of at least $$10\mathrm{.}00.$ The manager wants the results listed in descending order, based on each books$$ profit. $(4$ marks$)$

$4\mathrm{.}3$ A customer service representative is trying to identify all books in the Computer or Family life categories published by Publisher $1$ or Publisher $3.$ However, the results should not include any book selling for less than $$45\mathrm{.}00.$Write SQL code to achieve this query. $(5$ marks$)$

$4\mathrm{.}4$ Determine which books customer Jake Lucas purchased. Perform the search using the customer name, not the customer number. If he has purchased multiple copies of the same book, duplicate the results. Generate the report using the $($JOIN$.....$USING$)$ keywords. $(5$ marks$)$

$4\mathrm{.}5$ Which books where written by author with the last name Adams? Perform the search using the author name. Generate the report using the $($JOIN$...$USING$)$ keywords. $(5$ marks$)$

$4\mathrm{.}6$ Display the current day of the week, hour, minutes and seconds of the current date setting of the computer you are using. $(3$ marks$)$

$4\mathrm{.}7$ Create a list of all book titles as costs. Precede each book$$s cost with an asterisk so that the width of the displayed cost field is $12.$