Crowdly
Додати до Chrome
Retake | Database Management Systems | Aldiyar Salkenov
Шукаєте відповіді та рішення тестів для Retake | Database Management Systems | Aldiyar Salkenov? Перегляньте нашу велику колекцію перевірених відповідей для Retake | Database Management Systems | Aldiyar Salkenov в moodle.astanait.edu.kz.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
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.