인동머스크

Table: RequestAccepted+----------------+---------+| Column Name | Type |+----------------+---------+| requester_id | int || accepter_id | int || accept_date | date |+----------------+---------+(requester_id, accepter_id) is the primary key (combination of columns with unique values) for this table.This table contains the ID of the user who sent the request, the ID of the..

Table: Customer+-------------+---------+| Column Name | Type |+-------------+---------+| customer_id | int || product_key | int |+-------------+---------+This table may contain duplicates rows. customer_id is not NULL.product_key is a foreign key (reference column) to Product table. Table: Product+-------------+---------+| Column Name | Type |+-------------+---------+| product_key ..

Table: Scores+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || score | decimal |+-------------+---------+id is the primary key (column with unique values) for this table.Each row of this table contains the score of a game. Score is a floating point value with two decimal places. Write a solution to find the rank of the scores. The ranking..

Table: Queue+-------------+---------+| Column Name | Type |+-------------+---------+| person_id | int || person_name | varchar || weight | int || turn | int |+-------------+---------+person_id column contains unique values.This table has the information about all people waiting for a bus.The person_id and turn columns will contain all numbers from 1 to n, where n is ..

Table: Seat+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || student | varchar |+-------------+---------+id is the primary key (unique value) column for this table.Each row of this table indicates the name and the ID of a student.The ID sequence always starts from 1 and increments continuously. Write a solution to swap the seat id of every ..

Table: Tree+-------------+------+| Column Name | Type |+-------------+------+| id | int || p_id | int |+-------------+------+id is the column with unique values for this table.Each row of this table contains information about the id of a node and the id of its parent node in a tree.The given structure is always a valid tree. Each node in the tree can be one of three types:"Leaf..

Table: Stocks+---------------+---------+| Column Name | Type |+---------------+---------+| stock_name | varchar || operation | enum || operation_day | int || price | int |+---------------+---------+(stock_name, operation_day) is the primary key (combination of columns with unique values) for this table.The operation column is an ENUM (category) of type ('Sell', 'Bu..

Generate the following two result sets:Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in parentheses). For example: AnActorName(A), ADoctorName(D), AProfessorName(P), and ASingerName(S).Query the number of ocurrences of each occupation in OCCUPATIONS. Sort the occurrences in ascendin..

Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output column headers should be Doctor, Professor, Singer, and Actor, respectively.Note: Print NULL when there are no more names corresponding to an occupation.Input FormatThe OCCUPATIONS table is described as follows:Occupation will only contain one of..

You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. Write a query to find the node type of Binary Tree ordered by the value of the node. Output one of the following for each node: Root: If node is root node.Leaf: If node is leaf node.Inner: If node is neither root nor leaf node. Sample Output1 Leaf2 Inner3 ..