Question: Write SQL Statements corresponding to the English statements given below and execule them. Capture the results and put them into a word document. Write general


Write SQL Statements corresponding to the English statements given below and execule them. Capture the results and put them into a word document. Write general queries using functions that manipulate date whenever the query involves computation with "Date/Time" data type. Also, get today's date from the system using appropriate functions. 1. List customers from Tennessee (TN) who bought cat merchandise. 2. List the name and phone number of each customer who adopted an animal in the first fifteens days of February 2013. 3. List employee id, first name, last name and manager's last name and address for all the employees who are managed by Katy Reasoner. 4. Which adoption groups have placed more than 25 animals? 5. Which category of items had the highest sales value in May of 2013 ? 6. Which category of items were sold the most in the last ten years? Sally's Pet Store Schema \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ AdoptionGroup } \\ \hline AdoptionlD \\ AdoptionSource \\ ContactName \\ ContactPhone \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Animal } \\ \hline AnimallD \\ Name \\ Category \\ Breed \\ DateBorn \\ Gender \\ Registered \\ Color \\ Photo \\ ImageFile \\ Imageheight \\ ImageWidth \\ AdoptionID \\ SalelD \\ Donation \\ \hline \multicolumn{1}{|c|}{ Customer } \\ \hline CustomerID Phone FirstName LastName Address ZIPCode CitylD \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
