[solved]-Code Works Question Restrict Sun 5th 6th Digits 72 Without Pattern Matching Characters Sel Q39006553

here is my code, it works, my only question is how to restrictthe sun where the 5th and 6th digits are ’72’ without the patternmatching characters ‘%’ and ‘_’

SELECT ‘editor’, firstname, lastname
FROM editor
UNION
SELECT ‘author’, firstname, lastname
FROM author;

1. Code a SQL statement that uses a UNION between the firstname and lastname of the editor and author tables where the 5th through 6th digits of the Social Security number are ’72’. IMPORTANT: Do NOT use the pattern matching characters, ‘%’ and ‘_’ in your answer!! Also be sure to use a string expression to indicate whether or not someone is an author or editor in the result set. Show transcribed image text 1. Code a SQL statement that uses a UNION between the firstname and lastname of the editor and author tables where the 5th through 6th digits of the Social Security number are ’72’. IMPORTANT: Do NOT use the pattern matching characters, ‘%’ and ‘_’ in your answer!! Also be sure to use a string expression to indicate whether or not someone is an author or editor in the result set.

Expert Answer

---

Answer to here is my code, it works, my only question is how to restrict the sun where the 5th and 6th digits are ’72’ without the… . . .