Consider the STUDENT table above. Queries based on the concatenation operator: 1. Write a query to...

 

Transcribed Image Text:

Consider the STUDENT table above. Queries based on the concatenation operator: 1. Write a query to display student ID and the name together. 2. Write a query to display names and ages of the students. 3. Write a query to display the message like-'Student Salim Al Jabri is a good student for all the students. 4. Write a query to display the message like-'Student Salim Al Jabri is a good student for only Salim. 5. Write a query to display the message like-'Student Salim Al Jabri will be 27 years after two years' for all the students. Queries based on the distinct clause: 1. Write a query to display the courses taken by the students. 2. Write a query to display different ages of students in the student table. ST_ID 725555 725111 721212 765333 721524 725123 721444 765433 761524 STNAME Rahma Al Badi Amal Al Hatmi Salim Al Jabri Maha Al Shukaili Ahmed Al Kaabi Amal Al Hatmi Salim Al Jabri Maha Al Shukaili Ahmed Al Kaabi AGE 22 25 20 19 20 21 20 19 GRADE 3.05 2.5 3.1 3.23 2.14 3.25 3.1 3.23 2.14 C_ID 1T2 IT1 IT1 BS1 IT2 IT1 BS1 IT2 Consider the STUDENT table above. Queries based on the concatenation operator: 1. Write a query to display student ID and the name together. 2. Write a query to display names and ages of the students. 3. Write a query to display the message like-'Student Salim Al Jabri is a good student for all the students. 4. Write a query to display the message like-'Student Salim Al Jabri is a good student for only Salim. 5. Write a query to display the message like-'Student Salim Al Jabri will be 27 years after two years' for all the students. Queries based on the distinct clause: 1. Write a query to display the courses taken by the students. 2. Write a query to display different ages of students in the student table. ST_ID 725555 725111 721212 765333 721524 725123 721444 765433 761524 STNAME Rahma Al Badi Amal Al Hatmi Salim Al Jabri Maha Al Shukaili Ahmed Al Kaabi Amal Al Hatmi Salim Al Jabri Maha Al Shukaili Ahmed Al Kaabi AGE 22 25 20 19 20 21 20 19 GRADE 3.05 2.5 3.1 3.23 2.14 3.25 3.1 3.23 2.14 C_ID 1T2 IT1 IT1 BS1 IT2 IT1 BS1 IT2

Answer rating: 100% (QA)

The images youve provided outline several SQL query tasks that need to be written for a given STUDEN... View the full answer