Answer to Question #297833 in Databases | SQL | Oracle | MS Access for Talha

Question

Consider the following table “Students”:

stu_id class Rep Study_Group Gender

001 12 Muhammad Ali Science Male

002 11 Arham Arts Male

003 12 Maham Science Female

004 12 Maira Arts Female

005 11 Abdullah Science Male

And perform the following tasks:

⦁ Write a Hive query that changes the column name “Rep” and set it as “Student Name”.

⦁ Write a Hive query that only shows the record of female students.

⦁ Write a Hive query that changes the name of the “Students” table and sets its name as “Students_Record”.

Answer 1

It's been a while since this question is posted here. Still, the answer hasn't been got. Consider converting this question to a fully qualified assignment, and we will try to assist. Please click the link below to proceed: Submit order