Solution :

Step 1 : Select all the columns from product table with output header as below. productID AS ID code AS Code name AS Description price AS "Unit Price'

val results = sqlContext.sql(......SELECT productID AS ID, code AS Code, name AS Description, price AS Unit Price' FROM products ORDER BY ID"""

results.show()

Step 2 : Select code and name both separated by ' -' and header name should be "Product Description.

val results = sqlContext.sql(......SELECT CONCAT(code,' -', name) AS Product Description, price FROM products""" )

results.showQ

Step 3 : Select all distinct prices.

val results = sqlContext.sql(......SELECT DISTINCT price AS Distinct Price" FROM products......)

results.show()

Step 4 : Select distinct price and name combination.

val results = sqlContext.sql(......SELECT DISTINCT price, name FROM products""" )

results. showQ

Step 5 : Select all price data sorted by both code and productID combination.

val results = sqlContext.sql('.....SELECT' FROM products ORDER BY code, productID'.....)

results.show()

Step 6 : count number of products.

val results = sqlContext.sql(......SELECT COUNT(') AS 'Count' FROM products......)

results.show()

Step 7 : Count number of products for each code.

val results = sqlContext.sql(......SELECT code, COUNT('} FROM products GROUP BY code......)

results. showQ

val results = sqlContext.sql(......SELECT code, COUNT('} AS count FROM products GROUP BY code ORDER BY count DESC......)

results. showQ