Did you know that JSON parsing has an evil brother called XML parsing? Well, here he is and is ready to be defeated.
Starting Code Here
create table week49 (
data variant
);
insert into week49
select parse_xml('<?xml version="1.0" encoding="UTF-8"?>
<library>
<book>
<title>The Great Gatsby</title>
<author>F. Scott Fitzgerald</author>
<year>1925</year>
<publisher>Scribner</publisher>
</book>
<book>
<title>To Kill a Mockingbird</title>
<author>Harper Lee</author>
<year>1960</year>
<publisher>J. B. Lippincott & Co.</publisher>
</book>
<book>
<title>1984</title>
<author>George Orwell</author>
<year>1949</year>
<publisher>Secker & Warburg</publisher>
</book>
</library>
');
Your result should look like the below

Remember, if you want to participate:
My first time actually trying to parse XML through Snowflake. Thanks for providing a simple structure for the challenge!
Thanks for the challenge. No matter what day of the week, or what time of day…I truly dislike xml…