1. Numbers are not aligned right by default eg
You could report a bug/enhancement request for this. If I create a table the alignment will be set to horizontal alignment "default". But "default" will never be saved. It will be "left" instead. Could be it is planned but not implemented yet.
2. Maybe it's because numbers are converted to strings to display eg
No, test it with a new table. You could see every content is aligned left in the table.
I don't understand why different quote treatments are required for numbers
Step 4 1) Type >0 in the Criterion cell under FuelID in the query table.
Step 8 4) Type > '0' in the Criterion cell.
If I test it with LO 18.104.22.168 there are no quotes around numbers in the GUI. If I try to set quotes here it give a warning:
The entered criterion cannot be compared with this field.
I could only set quotes in SQL view but it will end with an error if I set it back to design view.
The quotes in the example are wrong for the GUI of Base and LO 22.214.171.124
It seems also the screenshots were made with different county format. There is a decimal separator '.' for $ and a decimal separator ',' for all other decimals.