mysql> select * from song; +-----+ | ID | Title +-----+- 100 | Hey Jude --+ | Artist | GenreCode | Beatles | PRC 200 | You Belong With Me | Taylor Swift | NULL 300 Need You Now 400 Old Town Road | Lady Antebellum | COU | NULL Lil Nas X | Pearl Jam 500 | That's The Way Love Goes | Janet Jackson | RAB 600 | Even Flow +-----+-- 6 rows in set (0.00 sec) mysql> desc song; | GRU + | Field ID | Type | int | Null | Key | Default | Extra | -----+-----+- Title | NO varchar(60) | YES | PRI | NULL | | NULL Artist | varchar(60) | YES | | NULL | GenreCode | char(3) | YES | MUL | NULL +- 4 rows in set (0.00 sec) mysql> select * from genre; +------+-- | Code | Name +----- | CLA artists | Description | Classical | Orchestral music composed and performed by professionally trained | | COU❘ Country | Developed mostly in southern USA, with roots in traditional folk music, spirituals and blues | | DRO | Drone clusters GRU | Grunge Pop Rock R&B | PRC RAB | TEC | Techno + | Minimalist music that emphasizes sustained or repeated sounds, notes, or tone | Alternative rock inspired by hardcore punk, heavy metal, and indie rock | Rock music with less attitude Modern version of soul and funk African-American pop music | Electronic music 7 rows in set (0.01 sec) mysql> desc genre; | Field | Code Name | Type | Null | Key | Default | Extra | | NO | PRI | NULL |char(3) varchar(20) | YES | Description | varchar(200) | YES + 3 rows in set (0.01 sec) | NULL | NULL

17. List the network names and the number of shows per network. Take a screenshot now and paste it here. 18. List the average number of episodes in the table shows. Take a screenshot now and paste it here. 19. List the name of the shows that have more episodes than the average number of episodes in the table shows. Use a subquery. Do not hardcode the average number (that you obtained in the previous question). Take a screenshot now and paste it here.

Objectives– Demonstrate use of associative arrays- Demonstrate knowledge of use of $_GET super global variable in data validation- Demonstrate handling of missing data in $_GETPHP $_GET is a PHP super global variable that can be used to collect form data after submitting an HTML form with method="get". The PHP $_GET super global variable can be used to collect data sent in the URL.Task: You will modify given code, part-2.php, to collect a course number and display its title. For instance, user will click on the hyperlink CSIS152, and this will cause the corresponding title “Introduction to Computers and Programming I-a”, to be displayed.1. Create an associative array, to reflect data in the following table. Store the array in a variable    called $electives. (see pages 44 and 45 in course text)  Key Value CSIS-335 Graphical User Interface Programming SIS-336 C#.Net Programming CSIS-341 System and Network Administration CSIS-360 Linux Programming and…

In the range C15:G15, insert a function to calculate the total daily revenue. In the range H11:H15, insert a function to calculate the weekly totals for the seating categories and grand total. What are the functions?

How to Create the Product webpage of Chapter 11 working with images and icons. Halloween 11 Create a product page In this exercise, you’ll create a product page that uses a variety of features for working with images. When you’re through, the page should look similar to this:   Specifications • To create the product page, you can copy the index.html file you worked on in exercise 7 to the products folder and rename it cat.html. Then, you can delete the content from the section, modify the URLs on the page as necessary, and add the content shown above. • Create a new style sheet named product.css for the product page, and copy the styles you need from the main.css file to this style sheet. Then, modify the link element for the style sheet in the cat.html file so it points to the correct style sheet. • Modify the horizontal navigation menu so it indicates that no page is current. • In the section, float the image to the left of the text. In addition, set the left margin for the text so…

1

3 4 Matching Drag the letter from the list on the right to its matching term in the list on the left. When you are finished, click Done. $ IDI 4 Formula AVERAGE Range name COUNT ROUND Links worksheets F2 AutoSum Trace Precedents Evaluate Formula fs Excel - Chapter 2 - Working with Formulas and Functions % 5 16 6 Q Search f7 4- & 7 A Enables the current cell's Edit mode: [B] Button that shows all cells referenced in the active cell's formula C A built-in function that calculates the arithmetic mean of a range of cells D This button opens a list of commonly used statistical functions EA label assigned to a single cell or group of cells. [F] Uses common arithmetic operations to perform calculations G Tallies the number of cells in a range H 3D cell reference U Button that starts a review of each part of a formula to determine errors J An Excel function that controls how many decimal places display for a value fa * 8 fg 144 9 110 11 ► ) O fy ADI 6 Reset Done + ins L prt sc t d