You own a recruiting agency and you are trying to analyze data from the recruiting process.

After doing a data pull, you have a database containing 2 tables - interviews and positions.

The interviews table contains the following columns:
- id: a unique ID for each interview session
- position_id: ID for the position that the interview was for
- candidate_id: ID for the candidate that was interviewed
- score: overall interview rating (1 to 5)

The positions table contains the following columns:
- id: a unique ID for each position
- company: the name of the company that is recruiting for the position

If the score for the interview is greater than or equal to 4, the candidate is considered to have successfully passed the interview.

Your task is to implement a query to calculate the sum of all interviews with successful scores (score >= 4) and the count of successful interviews, for each company. If a company did not have any successful interviews for any positions, return 0. The final output should be ordered by company name in increasing order. Show More

You are helping your professor at the university to generate a report containing three columns: name, grade, and mark. You are given a table of grades and students. Your professor has instructed you to create the report according to the following specifications:

- He doesn't want the names of those students who received a grade lower than 'C'.
- Higher grades in the report should be entered fi rst.
- If there is more than one student with the same grade (C - A) assigned to them, order those particular students by their name alphabetically.
- Finally, if the grade is lower than 'C', use "NULL" as their name and list them by their grades in descending order. If there is more than one student with the same grade (F - D) assigned to them, order those particular students by their marks in ascending order.

The grades table contains the following columns:
- grade: letter from A to F
- min_mark: the minimum mark a student must achieve in order to reach this particular letter grade
- max_mark: the maximum mark a student can achieve in order to get this particular grade Show More

Question: The kingdom has been given terrible news: the King has passed away. While the nation is mourning, the noblemen need to decide who will take the throne next.

The late King had many children, and now it is necessary to determine their order of succession according to their seniority.

The list of the King's children is represented as a table "Successors" with the following attributes:
- name: the child's name
- birthday: the date of their birthday (it is guaranteed that birthday dates are unique)
- gender: their gender (a character equal to 'M' or 'F')

The resulting table should contain the names of the King's heirs in order of their succession to the throne as determined by their age, and preceded by their potential future titles (i.e. "King name" or "Queen name").

Example:

For the following table "Successors":

| name | gender | birthday |
|--------|--------|------------|
| Amelia | F | 1711-06-10 | Show More

Your boss wants to identify the successful projects running in your company, so he asked you to prepare a list of all the currently active projects and their average monthly income.

You have stored the information about these projects in a simple database with a single Projects table that has five columns:

- internal_id: the company's internal identifier for the project
- project_name: the official name of the project
- team_size: the number of employees working on the project
- team_lead: the name of the project manager
- income: the average monthly income of the project

Your boss says that internal project ids are irrelevant to him and that he isn't interested in how big the teams are. Since that's the case, he wants you to create another table by removing the internal_id and team_size columns from the existing Projects table. Return it sorted by internal_id in ascending order.

Example:

For the following table Projects:
| internal_id | project_name | team_size | team_lead | income |
|-------------|--------------|-----------|-----------|--------|
| 101 | ManRoduce | 15 | John Doe | 50000 |
| 102 | WebScribe | 10 | Jane Smith| 30000 |
| 103 | DataFlow | 20 | Sam Black | 70000 |

You need to return the following table:

| project_name | team_lead | income |
|--------------|-----------|--------|
| ManRoduce | John Doe | 50000 |
| WebScribe | Jane Smith| 30000 |
| DataFlow | Sam Black | 70000 | Show More

The longest diagonals of a square matrix are defined as follows:
- The first longest diagonal goes from the top-left corner to the bottom-right corner.
- The second longest diagonal goes from the top-right corner to the bottom-left corner.

Given a square matrix, your task is to swap its longest diagonals by exchanging their elements at the corresponding positions.

Example:

matrix = [[1, 2, 3],
[4, 5, 6],
[7, 8, 9]] Show More