Question

6. Regular Expressions/SQL.

Write SQL for the following problems on the university database.

A. Find students whose name is properly capitalized (both first and last name start from an upper-case letter, rest of the name is lower-case). Hint: you can use [A-Z] to represent any upper case letter in regular expressions.

B. Find course titles that consist of exactly 3 words (e.g., “Theory of Computation”).

C. Find students whose SSN numbers has a pattern of 321 repeated twice (sequentially).

Answer 1

a) select *
from student_table
where firstname LIKE '[A-Z]%' and lastname LIKE '[A-Z]%';

b)select *
from course
where course_title LIKE '% % %';

c)select *
from student_table
where ssn LIKE '%321321% OR '321321%' OR '%321321';