What you have learned up to now


Problem

Parse the JSON files below into two SQL tables; One will be StateHospital and the other Hospital; once in SQL calculate the min, max, avg, and total of hospital beds for the whole state, by rural areas and by urban areas; After those calculations, add two fictitious hospitals at the hospital table populating at least 10 fields/columns, update the records you inserted, then delete those records you added, in summary, apply all the statements you learned this week plus what you have learned up to now (need to have a user-defined function at minimum). Make sure to use try/exception to avoid code-breaking.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: What you have learned up to now
Reference No:- TGS03256610

Expected delivery within 24 Hours