`
Write your MySQL query statement below
select (
case
when id % 2 = 0 then id - 1
when id = (select max(id) from seat) then id
else id + 1
end
) as id, student
from seat
order by id;
`
We're a place where coders share, stay up-to-date and grow their careers.
For further actions, you may consider blocking this person and/or reporting abuse
Francisco Zanfranceschi -
Rijwan Ansari -
Marco Antonio Bet -
Bryce Dorn -
Once suspended, chiki1601 will not be able to comment or publish posts until their suspension is removed.
Once unsuspended, chiki1601 will be able to comment and publish posts again.
Once unpublished, all posts by chiki1601 will become hidden and only accessible to themselves.
If chiki1601 is not suspended, they can still re-publish their posts from their dashboard.
Once unpublished, this post will become invisible to the public and only accessible to Miss Pooja Anilkumar Patel.
They can still re-publish the post if they are not suspended.
Thanks for keeping DEV Community safe. Here is what you can do to flag chiki1601:
Unflagging chiki1601 will restore default visibility to their posts.
Discussion (0)