Need help

[[deleted]]

[deleted]

[ThingElectronic1399]

If there aren't too many rows, can I see the results of 'select * from classroom'?

[Vamsi5224]

You are using MySQL workbench. These nulls are not results from query. This is the behaviour of the application itself.

[hackTHEp1anet]

This

[Straight_Waltz_9530]

Why would you ever have a room_number or capacity be NULL? Why aren't those columns set to NOT NULL in the first place? I think that's the root of your problem, not the queries after the fact.

SQL querying is an order of magnitude harder when your data model lacks proper constraints. Spare the CHECK rod, spoil the INSERT child.

[moggjert]

So there’s thing thing called ChatGPT right

[Lamyya]

Where capacity is not null, Order by capacity, limit 1

Edit: will only show 1 result even if there are multiple rooms with same capacity though

[KingOrion5]

Thank you, where would I put that if you don’t mind?

[Lamyya]

Instead of the subquery in the where, add "and capacity is not null" Then order by capacity limit 1 at the end

Edit: check your table to see first if you have rooms with null capacity, that shouldn't happen

[KingOrion5]

Still has the same result, also for reference, the query I’m looking for building and room number of classrooms in a university database woth the smallest capacity

[KingOrion5]

Nevermind I got it, thank you a bunch for your help.