Can we get list price and the price for each price level of an inventory item through suiteql?

Yeah you can use the pricing table to get all the prices, join to the pricelevel table to get the price level's name (rather than internal id) for readability purposes.

Can you provide the query for it. I have gone through the pricing table, but didn't find a way to join it with the item table. I want the prices for a few specific price levels for that item.

if you don't need the item name, you don't need the item table, but if you want to join them then it's the item field in the pricing table that is the item's internal id

I thought by pricing table you mean InvtItemPriceHistory. I didn't know the pricing table exist, as it was not available in SuiteQL query tool. Thank you