The following oracle column is deprecated: person.hobby_name. This needs replaced with a join to the hobby table on person.id=hobby.person_id and replace the person.hobby_name with hobby.name. person table has a one-to-many relationship to the hobby table, so the listagg function needs to be used to list all hobbies per person on one line.

Example
Current Query: select person.name, person.hobby_name from person
Fixed Query: select distinct person.name, listagg(hobby.name) over(partition by person.id) as hobby_name from person left join hobby on person.id = hobby.person_id


Fix the rest of theae queries if they need fixed

Query 1: select p.name from person p 
Query 2: select p.name, p.hobby_name from person p Write your response with exactly 2 paragraphs, separated with the markdown divider: ***.
user