bantam | A simple demo app for Pratt parsing

We could use regex_left_join from fuzzyjoin

SQL is really easy to learn when you want to! (I see your syntax is = sql, correct me if I'm wrong lol)

I see you are getting those errors because your constraints you did made.
To fix the issue you can use the ALTER TABLE tableName NOCHECK CONSTRAINT constraintName for a specific constraint or ALTER TABLE tableName NOCHECK CONSTRAINT ALL for all constraints.

And you can again just enable them by ALTER TABLE tableName WITH CHECK CHECK CONSTRAINT constraintName for a specific constraint or ALTER TABLE tableName WITH CHECK CHECK CONSTRAINT ALL for all constraints.

I did re-write all of the above per section in a SQLFIDDLE for you... I did only fix the first issue for you by using the method above... I did not touch the others since you want to learn. Let me know if you got stuck so I can help you where you got stuck.
DBFiddle Link

That will be the EASY solutions and not long term solution
If you want a long term solution wait for my edits below:

Update #1 First fixed issue

We can reshape to 'long' format with pivot_longer, then do a count and reshape it back to 'wide'

Resolved this issue by referring to the plotly figure reference.

According to the documentation categoryarray can be used to set the order in which categories in an axis appear.

This is what I wrote:

Your columns are not aligned and your data length is too small for your given data.

The error

total-bouts-v-bouts-won.figure ValueError: Invalid properties specified for object of type plotly.graph_objs.layout.YAxis: ('1', 'b', 't', 'r')

is because of your layout definition:

This is a sample of one line of the OP's XML file
109555912.69

The OP wants to use the IMPORTXML function to report the ID and Name as well as the Job Cost from the XML data. Presently, the OP's formula is:
=importxml("link","//job-base-cost")

There are two options:
1 - One long column
=importxml("link","//@id | //@name | //job-base-cost")

Note //@id and //@name in the xpath query: // indicate nodes in the document (at any level, not just the root level) and @ indicate attributes. The pipe | operator indicates AND. So the plain english query is to display the id, name and job-base-cost.

2 - Three columns (table format)
={IMPORTXML("link","//@name"),IMPORTXML("link","//job-base-cost"),IMPORTXML("link","//@id")}

This creates a series that will display the fields in each of three columns.

Note: there is an arrayformula that uses a single importXML function described in How do I return multiple columns of data using ImportXML in Google Spreadsheets?. Readers may want to look at whether that option can be implemented.

My thanks to @Tanaike for his comment which spurred me to look at how xpath works.

Wikipedia is, first off, HTML-oriented if we can say it, and it has little sense to convert HTML to JSON (rhetorically: which JSON format by the way?), so it justs returns a portion of HTML do be displayed in an arbitrary HTML viewer. What you have to do here is:

• Make an API call to get a well-formed JSON response (you're doing it with Volley).
• Extract the quotes HTML from the JSON response.
• Extract the quotes from the HTML extracted in the previous step.
• Display the quotes somehow.

I just dumped that response as of April 5, 2017, and the following example suggests one possible solution using plain Java with org.json and JSoup: