Question 11

Table Name: College

Relevant Table: College(Professor (Text), Department (text), Salary (INT))

Professor Department  Salary
John Computer Science 60,000
Van der Mechanical Engineering 57,500
Ackerman Physics 45,000
Suyash Mathematics 52,000
Simrit Computer Science 56,500
Jessica Computer Science 55,000
Jenny Personality Development 50,000

QUERY: Write a Query that returns all the Professor names that begin with the letter "J".

Execute:     SELECT Professor
                   FROM College
                   WHERE Professor LIKE 'J%';

Answer:

Professor
John
Jessica
Jenny