So I am dealing with a project where we have entities that have a name, and while multiple entities can have the same name only one of those entities can be active at a time. Therefore for every update/insert if the new/updated entity has active = TRUE, all other entries with that name have to have active = FALSE.

so i want to show the avg billing of all the restaurants at a particular pincode and also list of every restaurants at that pincode

The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query

The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query

The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query

The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query

The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query

The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query

The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query

The table name is Employee, here is the table below, I need to switch the departments so that John is purchasing and Jenn is accounting, but in a single query