Using the corrected code from Step 28, include the Select into a temporary table named temptable. Prove your creation by run running a list from temptable where the title includes the characters eng. Hint: wildcard characters needed on your where clause.corrected code from step 28: select last_name, first_name, title, max(t.to_date), dept_name from employees e join titles t on e.emp_no = t.emp_no join dept_emp de on e.emp_no = de.emp_no join departments d on de.dept_no = d.dept_no group by e.emp_no order by last_name, first_name;

The query in the step 28 results in a table of values. Now,this table has to be stored in a temporary table. The temptable contains the attributes last_name, first_name, title, max(t.to_date), dept_name. so, create temptable with these attributes. The next step is to select some rows from the temptable where there is a condition on title attribute. We need to use wildcard charactes like _, %, [], ^ etc. Step1: create temptable with the attributes create table temptable(last_name varchar(20), first_name varchar(20), title varchar(20), to_date date, dept_name varchar(20)). Now, the table to store the output of select query is created. Step2: Insert the output table into temptable. this is similar to inserting values into the table. INSERT INTO temptable values( SELECT last_name, first_name, title, max(t.to_date), dept_name from employees e join titles t on e.emp_no = t.emp_no join dept_emp de on e.emp_no = de.emp_no join departments d on de.dept_no = d.dept_no group by e.emp_no order by last_name, first_name ) Now, temptable contains the values returned by the select query. Step3: Check the strings in title column using some wildcard characters. The wildcard characters are some type of special characters in SQL that are used to find a character or some sequence of characters in a string. These are used in comparison of strings. for example, title column is having some values like step, character, bold, itliac, icecream, balloon, ball, bun,..... ---->>> if we have to find the strings that starts with b, the query will be: select * from temptable where title='b%' the above query gives the rows having title column with these three strings i.e. bold, balloon, ball. No other string starts with b other than these three. b can be replaced by any character. ----->>> to select the strings that starts with b and ends with l. select * from temptable where title='b%l' the output will be the rows containing their title column as ball only. It starts with b and ends with l. ----->>> to select the string starts with b and ends with n and only one character in between. select * from temptable where title='b_n' the output will be the rows containing their title column in the format b_n. any character can be in that place. % is used to match zero or more characters. _ is used to match only a single character. ---->>> to select the string starts with b and ends with n and only one character in range(like a to d) in between. select * from temptable where title='b[a-d]n' The strings can be ban,bbn,bcn,bdn. Only these can be selected. bun is not selected in this case. By putting ^ or ! i.e [^a-d] , the strings other than a,b,c,d are selected. Means ban, bbn,bcn,bdn will not be selected. bun will be selected. These are some wildcard characters that can be used in SQL queries.