- SQL: Freelance Platform Candidate Review
A company's HR department needs an SQL query against data from a freelance hiring platform.
The result should have the following columns:
first_name | last_name | email | job_success_score
It should be sorted in descending order by job_success_score, then in ascending order by first_name and last_name.
Limit the result to the first ten records.
Note:
- Only profiles that have a "JSS" (Job Success Score) greater than 90 should be included.
- Only those profiles that have passed the verification process (is_verified is 1) should be included.
- Probability - II
In a family, the probability that at least one parent falls ill is 20%. If the probability that the father falls ill is 12% and the probability that both the parents fall ill is 5%, what is the probability that the mother falls ill?
Pick ONE option:
- 3%
- [●] 13%
- 10%
- 8%
- Sampling
A given population has been divided into 3 categories along with the number of samples as shown below. 10 samples are picked randomly using the stratified method. What will be the distribution of each category in the sample?
| Category | Size |
|---|---|
| A | 50 |
| B | 40 |
| C | 10 |
| Total | 100 |
Pick ONE option:
- [●] A - 5 B - 4 C - 1
- A - 10 B - 0 C - 0
- A - 4 B - 3 C - 3
- A - 0 B - 5 C - 5
- Verify Sale Order
Given the dataset of the orders containing expected goods to be received and sold each month, find if this order can be fulfilled or not.
- For each date_added and each size, find the number of goods received and sold.
- If the number of goods received >= number of goods sold, then the order is "Possible", else it is "Not Possible".
The given pandas dataframe consists of four columns:
- id: unique id
- date_added: date at which goods are received or sold (YYYY-MM).
- type: whether the goods are "Received" or "Sold".
- sizes: different sizes in which the goods are available, each separated by '/'.
Consider, for example, you are given the following dataframe:
| id | date_added | type | sizes |
|---|---|---|---|
| 1 | 2016-02 | Received | 7/8/9 |
| 2 | 2016-02 | Sold | 8/9 |
| 3 | 2016-03 | Received | 36/37 |
For the month of 2016-02, goods are received for sizes 7, 8, and 9, whereas sold for 8 and 9. Since sold goods are less than goods received, it is Possible.
For the month of 2016-03, goods are received for sizes 36 and 37, whereas no goods are sold. Since sold goods are less than goods received, it is Possible.
Since for both months, conditions are satisfied, this Sale Order is Possible.
Function Description
Complete the function saleOrder in the editor below. The function processes a dataframe as described in the statement.
saleOrder has the following parameter(s):
- df: a pandas dataframe
Constraints
- Assume quantity to be 1 for each size for each id.
我们长期稳定承接各大科技公司如TikTok、Google、Amazon等的OA笔试代写服务，确保满分通过。如有需求，请随时联系我们。
We consistently provide professional online assessment services for major tech companies like TikTok, Google, and Amazon, guaranteeing perfect scores. Feel free to contact us if you're interested.
