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 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;

View this question

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

View this question

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];

View this question

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?