Crowdly
Add to Chrome
Retake | Database Management Systems | Aldiyar Salkenov
Looking for Retake | Database Management Systems | Aldiyar Salkenov test answers and solutions? Browse our comprehensive collection of verified answers for Retake | Database Management Systems | Aldiyar Salkenov at moodle.astanait.edu.kz.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Which SQL statement allows you to find the total sales amount for Store ID 25 and the total sales amount for Store ID 45?
Table SALES
| Column Name |
| STORE_ID |
| SALES_DATE |
| SALES_AMOUNT |
EMP_IDNO EMP_FNAME EMP_LNAME EMP_DEPT
--------- --------------- --------------- ----------
127323 Michale Robbin 57
526689 Carlos Snares 63
843795 Enric Dosio 57
328717 Jhon Snares 63
444527 Joseph Dosni 47
659831 Zanifer Emily 47
847674 Kuleswar Sitaraman 57
748681 Henrey Gabriel 47
555935 Alex Manuel 57
539569 George Mardy 27
733843 Mario Saule 63
631548 Alan Snappy 27
839139 Maria Foster 57
Which SQL statement is the correct one to use to find the earliest date STORE_ID 10 had a sales amount greater than 0?
Table SALES
| Column Name |
| STORE_ID |
| SALES_DATE |
| SALES_AMOUNT |
Evaluate the following SQL statement:
SELECT promo_category, AVG(promo_cost) Avg_Cost, AVG(promo_cost)*.25 Avg_Overhead
FROM promotions
WHERE UPPER(promo_category) IN ('TV', 'INTERNET','POST')
GROUP BY Avg_Cost ORDER BY Avg_Overhead;
The above query generates an error on execution.
Which clause in the above SQL statement causes the error?
Which query finds the total weight of cats grouped by age, but only returns those groups with a total weight larger than 12 ordered by age?
Table schema:
| name | varchar |
| breed | varchar |
| weight | float |
| color | varchar |
| age | int |
SELECT COUNT(_____ id) FROM teachers WHERE semester = 'Spring' AND year = 2010;
If we do want to eliminate duplicates, we use the keyword _____ in the aggregate expression.