SQL I need a help/guide or sample on how to write sql to pull the below information:
SQL I need a help/guide or sample on how to write sql to pull the below information:
6. List all courses that have “Intro to Information Systems” as prerequisite (HINT: use a subquery)
7. For all students who have phone area code 212, change the code to 202 while keeping the same phone number (HINT: consider using functions such as SUBSTR and LENGTH)