Write an SQL statement that creates a view named CDView that contains columns cdid,cdlbid,cdtitle, cdyear, and cdlength(the first four are columns that exist in various tables, while the fifth must be calculated)

Label Track CD PK Ibtitle PK trkid PK cdid PO---OH DO-------OH Iblstreet trknum cdlblid Ibicity trktitle cdtitle Iblstate trklength cdyear Iblpostcode Ibination Label Track CD PK Ibtitle PK trkid PK cdid PO---OH DO-------OH Iblstreet trknum cdlblid Ibicity trktitle cdtitle Iblstate trklength cdyear Iblpostcode Ibination