Tаble 1: Thermаl vs. Vоltаge Failure Results (all 500 cоmpоnents) Voltage Failure No Voltage Failure Total Thermal Failure 50 85 135 No Thermal Failure 65 300 365 Total 115 385 500 Additionally the engineer reports: 70 components experienced a mechanical failure 40 of the components with mechanical failure also had a thermal failure 40 of the components with mechanical failure also had a voltage failure 10 components experienced all three failure types simultaneously Let A = thermal failure, B = voltage failure, C = mechanical failure What is the probability that a randomly selected component experiences exactly two types of failure?
[1] Sоme useful resоurces: MySQL Dоcumentаtion Structured Query Lаnguаge (SQL) Practice Resources [2] All of the queries are based on the following "global company" scenario: cs4400 global banking description.pdf [3] Submit your answers using this format (one of these per quiz question): create view examQuery as ...fill in your proposed answer here...; This is the same format that you've used when practicing with the company autograder in class over the past few weeks, the only exception being that you'll be using "examQuery" instead of "practiceQuery". You are NOT permitted to use any other code (e.g., extra views, functions, stored procedures, with clauses, etc.) to form your queries on this exam. [4] Also, please be sure to use the "as" operator to rename any duplicate columns in the select clauses of your queries. All column names must be unique for our evaluation system. The column names aren't actually evaluated by our testing system, but leaving duplicate column names in a single query can cause the evaluation and testing of your submission to fail. [5] There are no sorting requirements for this exam. Some of the PDFs might show the expected result set for the initial database state in a sorted just to make it easier for you to compare your answers. The rows in your result set don't have to match the order of the rows as shown in the output. The column order in your result set, however, must match the column order shown in the output for your query to be fully correct. [6] Finally, all of the queries involve the select command. Do not submit any other queries or transactions involving these commands or their variants: insert, update, delete, create (other than creating views to save your queries), alter, or drop.