how can I write an SQL script for those spific tasks  also by using the SHOW statment and the DESCRIBE statment when required? List the full names of the students who have taken a CIS course or a History course List the full names and GPA of the students who have taken a course List the full names and GPA of the students who have not taken a course List the full names and GPA of the students who have taken a course a 3 credit course

i am making a  of a data ware house for a shop . this is the draft I made . how could I draw this on SQL developer or oracle SQL ? what will it looks like batter ? include all the primary key / foreign key relationships it ?

SQL  SQL   Provide the StayWell Property Management team with a list of all property addresses combined with the name of the owners.   here is what i have so far but says query completed but nothing shows SELECT O.FIRST_NAME, O.LAST_NAME,P.ADDRESS   FROM OWNER AS O,PROPERTY AS P    two tables im grabbing the information from are attached owner table and property    expected outcome FIRST_NAME LAST_NAME ADDRESS Ernest Burke 30 West Thomas Rd. Ceyda Aksoy 782 Queen Ln. Nicole Bianchi 9800 Sunbeam Ave. Jakub Kowalczyk 105 North Illinois Rd. Haydon Sims 887 Vine Rd. Elle-May Moore 8 Laurel Dr. Meerab Cole 447 Goldfield St. Jakub Kowalczyk 594 Leatherwood Dr. Makesh Patel 504 Windsor Ave. Janine Lopez 891 Alton Dr. Ammarah Jones 9531 Sherwood Rd. Seth Redman 2 Bow Ridge Ave. Haydon Sims 916 Kent Drive

Thank you for helping! Write the SQL code to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table. The result is shown as below. Write the SQL code to display the information of employees who are working as either programmer or system analyst. Write the SQL code to produce job_descriptions(job_title) of employees who are working at project ‘Evergreen’.