Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started