Last week you developed a database of articles about softskills. This week we will earn about SQL and I will ask you to use it to write queries. Remember, I want you to write the queries and not just take the code generated by Microsoft when you enter in the user interface. So I want you to write the SQL. Then you need to send me the database with the SQL queries and just in case Microsoft does some "fixing" I want you to send me a list of the queries you wrote (you can send them in text, word or pasted into the email). If you need to add some data to have records meet the criteria, please do.
Problem #1: Write the code to look for credibility of 2 AND an opinion of 1 OR just an opinion of 2.
Problem #2: Write the code to look for a credibility of 1 AND an opinion of 2 OR look for a credibility of 2 AND an opinion of 1.
Problem #3: Write the code to look for opinion of 2 OR the year less than 2016 OR the criteria of 1.
Problem #4: Write the code to look for opinion of 1 AND either published in 2016 OR 2014.
Problem #5: Write the code to look for credibility of 1 and year published of 2016 OR opinion of 2 AND credibility of 2.
Problem #6: Write the code to look for year published of 2016 AND either opinion of 1 OR credibility of 1.