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 andexecule them. Capture the results and put them into a word document.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!