Given the following binary decoder-synthesised logic circuit, please select the equivalent multiplexer-synthesised circuit. Note: assume b2 is the most significant bit. 3-to-8 binary decoder yo b2, b1, b03b[2:0] y1 y2 уз y4 F y5 уб y7 Select one alternative: None of the others. b0 0 b01 b0 0 b01 b0 0 b1 b1 b1 b2 b0 1 0 b1 b0 0 b0 1 b0 -0 b01 b0 0 b01 b2 b1 0 F b2

In SQL, you use the __ statement to retrieve the rows in a table. Question 7 options: SELECT FROM WHERE QUERY

Determine the kind of books that are currently in stock. Each category should be represented by a single item.

Which clause of a SQL Select statement is required if we want to display aggregate data by category such as total population by state, department, etc.? Question 40 options: 1) GROUP BY 2) ORDER BY 3) WHERE 4) FROM 5) SELECT

Please pick out all the right options for this question thanks. Speed will be appreciated

Question 13: Evaluate ACE16 +102 10 and show the answer in octal form.

(1) for each Customer (e.g., customer C), display all other customers who have higher salary than this Customer (e.g., customer C). (use inner join, display each customer’s ID, name, and all higher salaries, you don’t need to display information about the customers who have higher salary.) (2) for each Customer (e.g., customer C), display all other customers who have higher salary and are younger than this Customer (e.g., customer C).

You may use the Boolean operator to search for data on two separate topics at once. To get the most relevant results, Kevin should utilize which of the following Boolean operators?

Write a select statement for the following: List all the foods on the menu and the total number of orders for each food item. (Note that broccoli does not show up in the result because no one has ordered it.)

On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate. Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.

Assume the PRODUCT table contains multiple rows. The following code would include: SELECT P_DESCRIPT, P_PRICE FROM PRODUCT WHERE P_CODE IN(SELECT P_CODE FROM LINE GROUP BY P_CODE HAVING COUNT(*) > 1); Group of answer choices A) Select the products that have been ordered before. B) Select the products that have been ordered at least once. C) Select the products that have been ordered at least twice. D) An error message.

Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below. Each column is the grades each student received. There are 8 students with 10 grades each. Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86 Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86 Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76 Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85 Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92 Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98 John: 79,0, 74, 96, 88.5, 88, 0, 100, 86, 83 Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79 Write user-defined functions or build-in functions (e.g., sum, mean, max, min, etc.) to calculate: The Average Grade of each student; this average should be a vector. The average of the class; this average is a scalar vector. The highest grade among the Average Grade of Each Student The lowest grade among the Average Grade of Each Student Show a table with each student's name, average grade and letter score using A, B, C, D, F...

Please answer accordingly..