Pages with porn should get the Porn flag even if the query is looking for porn results. a) True b) False

Challenge 1 v= Ⓒ Challenge #1 - Part 5 Task Determine what the sale price would be for each item if the Marketing team went off the rails and implemented a sale for 35% off the original price of all items! Once again, add this new column onto the end of your existing query and name it discount_35. ► Want a hint? III = query.sql + 1 SELECT *, original_price* (1 0.35) AS discount_35 2 FROM retail.products; 42442 3 5 product_id sku CT- BLK- 8 1 SQL Viewer 2 CT- BLK- 8.5 X + Cap Toe - Cap Toe product_type color size full_name category material created_at black 8.0 black 8.5 Cap Toe - Black - 8 Cap Toe - Black - 8.5 men men leather i leather X 2016-09- 12 2016-09- 12

Using the Winners table from Figure 12-2, write a parameter query that selects only ananimated picture’s Year field.

Guided Table Build: We will be Creating a Table called Student For the 6 following questions, your submission will be the query that shows you’ve created the table conforming to the requirements. Create a Table Named Student. The first column should be named ID, and have a data type of Integer The second column should be named First_Name, and have a data type of varchar(255). The third column should be named Last_Name, and have a data type of varchar(255) The fourth column should be named DOB (short for date of birth), and have a data type of date. The firth column should be named Adv_ID (short for advisor ID), and have a data type of integer.

part A Attempt to violate the primary key constraint and observe the result. part B Attempt to violate the foreign key constraint and observe the result

Question 5: Write a query to return the names of the books that Jenny Jennifers likes. Show the query and results. State the minimum number of nodes needed in the MATCH statement Question 6: Using A CREATE statement, add an edge between Jenny Jennifers and the book, "A Kiss too Far". Make the attribute of the edge be: "DISLIKES" (case sensitive, all in caps). This should be a directed edge pointing from Jenny Jennifers to the book that she dislikes.