01.tech

Analysis of fitness club attendance You work as an analyst in a chain of fitness clubs. You have information about user visits and the memberships they purchase. It is necessary to analyze the effectiveness of membership usage. Calculate for each type of membership: • the total number of users who used this type of membership. Consider only unique user_id; • the total number of visits for this membership. Consider all visits of users with this membership; • the share of users of this membership in percentage of the total number of all users (rounded to one decimal place). To calculate the share, use the ratio of the number of users with this membership to the total number of all unique users. Each user can have only one membership. Sort the result by membership type in alphabetical order. Input format Memberships table: • membership_id (int) — unique membership identifier • user_id (int) — unique user identifier • membership_type (text) — type of membership Visits table: • visit_id (int) — unique visit identifier • user_id (int) — user identifier • visit_date (timestamp) — date and time of visit Data does not contain missing or incorrect values. Output format The query should return a table with fields in this order: • membership_type (text) — type of membership • users_count (int) — number of unique users with this type of membership • total_visits (int) — total number of visits of users with this membership • user_share (numeric) — share of users of this membership in percentage of the total number (rounded to 1 decimal place) The result is sorted by membership type in alphabetical order.

What is load factor and how does it work?

Have you tested request idempotency? How exactly?

Which of the following code snippets contains an error or potential issue related to channel operations? Option 1 package main func main() { ch := make(chan int) ch <- 1 } Option 2 package main func main() { ch := make(chan int, 1) ch <- 1 } Option 3 package main func main() { ch := make(chan int, 1) ch <- 1 <-ch } Option 4 package main func main() { ch := make(chan int) close(ch) <-ch } Option 5 package main func main() { ch := make(chan int, 3) ch <- 4 }

Why did you choose WebSocket instead of SSE? Why is two-way communication needed if the frontend does not send data to the server?

What would you not like to do at your new job?

Are you willing to not accept an offer until we get feedback?

In array A, there are prices for N items. There are K coupons that reduce the item's price by X. If t coupons are applied to an item with price a, its final cost will be max(a - t*X, 0). Return the minimum amount of money needed to buy all items. A = 8, 3, 10, 5, 13 K = 4 X = 7 result=12 --- Given an array a of n positive integers, are there three distinct indices i, j, k such that the sum a[i]+a[j]+a[k] ends with the digit m? For example, for m = 3 solve([20, 22, 19, 84]) => true // 20 + 84 + 19 = 123 solve([1,2,3]) => false

What is bias for action?