Using database SHIPPING, which contains three tables: SHIP,…

Using database SHIPPING, which contains three tables: SHIP, SHIP_VOYAGE, and OWNER… to get all the fields from all the records in SHIP and any matching records in SHIP_VOYAGE, which would be the correct query? Note: There are other records in the table(s) that are not represented here. The query must work no matter what records are in the table(s).

Using database SHIPPING, which contains three tables: SHIP,…

Using database SHIPPING, which contains three tables: SHIP, SHIP_VOYAGE, and OWNER… which is the correct SELECT clause of a query that will retrieve the hull number, owner, and flag of each ship? Note: There are other records in the table(s) that are not represented here. The query must work no matter what records are in the table(s).

A two-stage, high-rate trickling filters treat 2.25 MGD of m…

A two-stage, high-rate trickling filters treat 2.25 MGD of municipal wastewater that has a BOD5 of 210 mg/L. The trickling filters are of equal diameter and depth and have equal recycle ratios. Other pertinent data for the facility are as follows: BOD5 applied to the trickling filter system: 158 mg/L after 25% of BOD5 removal in the primary clarification system Trickling filter diameter: 75 ft Trickling filter media depth: 6ft Required surface area of the two-stage trickling filter system: 4,418 ft2 (=0.1014 acres) Recycle ratio: 1.0 Using the NRC equations, determine the following parameters and solve the problems.   (4 pts) Determine the required volume of the two-stage trickling filter system (Unit: acre-ft). (4 pts) Determine organic mass loading to the two-stage trickling filter system (unit: lb BOD5/day). (4 pts) Determine trickling filter recycle factor (F). (4 pts) If the BOD5 removal efficiency of the first-stage trickling filter is 68.4%, what is the BOD5 applied to the second-stage trickling filter ? (unit: lb/day) (4 pts) If the BOD5 removal efficiency of the first-stage trickling filter is 68.4%, determine BOD5 removal efficiency (%) of the second-stage trickling filter. (Hint: V2 unit is acre-ft) (4 pts) If the BOD5 removal efficiency of the first-stage trickling filter and the second-stage trickling filter is 68.4% and 54.9%, respectively, what is the expected effluent BOD5 from the system (mg/L)?