use g00212878;

--Hint -- if you run into a mistake and to delete your table/temp table or view simply type
-- drop table <tablename> or drop view <viewname>


--1 Run the following query:
Select *
into #Temp1 
from Cust_orders 
where Payment = 'Cash';

--2 Run at select query for the temp table created above.

--3 Using Cust_orders - create a table table that contains all records for the electronics department.

--4 Union #Temp1 from step one with your temp tables from step 3

--5 Troubleshoo the query below.


  select   Tran_DT
      ,Dept
	  from (select * from #temp1);

--6 Click New Query (opening a new tab) -- Try to query #Temp1 from the new tab -- what happens?

--7 Now run the query below:
Select *
into Test_Table
from Cust_orders 
where Payment = 'Cash';

-- 8 Try querying Test_Table in a New Query Tab - what happens?

--9 -- Turn the query below into a View
Select s.Stud_NM as [Student Name], s.Start_dt as [Start Date], T.Subject,
t1.name as [Tutor Name]
from Student as s
join Tutoring as t
on s.Stud_ID = t.Student_ID
join tutor as t1
on t.Tutor_ID = t1.Tutor_ID

--10 -- Run a query from the view you just created where
-------Subject does not start with the letter G

--Bonus Question----
--11 -- Run a query from the view you just created where
-------tutor name does not end with the letter b