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 lets you find the sales amount for each store?

Table SALES

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES ORDER BY STORE_ID;

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES;

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES GROUP BY STORE_ID;

100%

SELECT STORE_ID, SUM(SALES_AMOUNT) FROM SALES HAVING UNIQUE STORE_ID;

Переглянути це питання

Table B

ID
1
2
3

Table C

ID
4
5
6

The below query is run on both of the above tables:

SELECT * FROM C UNION SELECT * FROM B UNION ALL SELECT * FROM C UNION ALL SELECT * FROM B

What will be the result of the query:

ID
1
2
3
4
5
6

ID
1
2
3
4
5
6
4
5
6
4
5
6

ID
1
2
3
4
5
6
4
6
1
2
3

ID
1
2
3
4
5
6
4
5
6
1
2
3

Переглянути це питання

The following query: SELECT [Name], [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY GROUPING SETS (([Name]), ([Year]))

Is equivalent with?

SELECT [Name], NULL AS [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Name] UNION ALL SELECT NULL AS [Name], [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Year];

SELECT [Name], [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Name] UNION ALL SELECT [Name], [Year], SUM([Sales]) FROM [dbo].[Orders] GROUP BY [Year];

SELECT [Name], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Name] UNION ALL SELECT [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Year];

SELECT [Name], NULL AS [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Name] UNION ALL SELECT NULL AS [Name], NULL AS [Year], SUM([Sales]) FROM [dbo].[Product] GROUP BY [Year];

Переглянути це питання

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?