I want to perform some simple formatting for a bar graph in Oracle Apex. In a numerical graph, given a value, I want to draw a horizontal line across the y axis at that value and any bars that contain values below that line should be coloured red and otherwise green. For example, if this is my [Bar Graph] and the value inputted is 33, only one bar should be green and the others red

I am trying to write an SQL query in Oracle Apex that accesses items in the page and then creates a graph based on that item. In this case, I want to display the last 5 games of a player that the user inputs.