233k views
4 votes
1. Display course title and credit concatenated as a format of "Course _Credit". 2. Find the longest department name which is a single word. 3. Find total credits of all courses that contain 'programming' in its titles. 4. Find name of each student or instructor who didn't take/teach any course in Fairchild building.

User Drkvogel
by
7.5k points

1 Answer

5 votes

Final answer:

The questions involve database manipulation and data analysis tasks, such as formatting text, finding the longest single word, summing specific records, and filtering based on criteria.

Step-by-step explanation:

The student's questions pertain to database queries and data analysis in a college course context, likely within a Computers and Technology subject. They are focused on manipulating and analyzing data to retrieve specific information, such as formatting course titles and credits, finding the name with the maximum length in single word, summing credits for courses with a specific keyword in their titles, and identifying individuals not associated with a specific location for courses.

User Nazariy Vlizlo
by
8.8k points