Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Describe loss aversion and myopic loss aversion.

Answered: 1 week ago