I need help with this MySQL

Google drive link to sql file https://drive.google.com/file/d/1_uFpzDhQzkXEKehz6zqlyHITHU6UngN8/view?usp=drivesdk

1. Use a SELECT with a CASE expression to list the authors contract status, last name and first name. If the contract value is 1 then display Contracted". If the contract value is 0 then display "No contract". Otherwise, display "Unknown status". Use the headers and sort order showrn 1 ConbractedC del Cantillo ContractedD Contracted Gnesby But Contracted DLeay Contractedinger Contracted gt ParteleySyia No contract stores Column Name decimali. Column Name Condereed Type Column Name Conderced Type Column Name llow Nulls dentty Condamed Type Condersed Type ttie.ld Column Name Column Name Condensed Type