Condition There is a database with the following data schema // user id | firstname | lastname | birth 1 | Ivan | Petrov | [phone] | Anna | Petrova | [phone] | Anna | Petrova | [phone] // purchase sku | price | user_id | date 1 | 5500 | 1 | [phone] | 5700 | 1 | [phone] | 4000 | 1 | [phone] | 8000 | 2 | [phone] | 400 | 2 | [phone] // ban_list user_id | date_from 1 | [phone] You need to output: 1. Display unique combinations of user and product id for all purchases made by users before they were banned. Sort first by user name, then by SKU. 2. Find users who made purchases totaling more than 5000 rubles. Display their id, name, surname, and total purchase amount in the format id | name | surname | total amount.
Python
10983
584
Middle
176
It is required to implement a function zip that combines elements of two slices into a slice of pairs ```go func main() { s1, s2 := []int{1, 2, 3}, []int{4, 5, 6, 7, 8} fmt.Println(zip(s1, s2)) // [[1 4] [2 5] [3 6]] } func zip(s1 []int, s2 []int) [][]int { //... } ```
Middle
150
2. Find users who have made purchases totaling more than 5000 rubles. Display their names in the format user id | first name | last name | total purchase amount
Middle
113
Tell me about your experience. What did you do at your last job?
Middle
109