Python
What happens if you call blocking code inside an async function? What will happen to the event loop?
amoCRMHave you used imperative model mapping in SQLAlchemy?
Why can't any data type be used as a dictionary key in Python?
How does a tuple containing a list differ from a tuple with numbers? What is it related to?
СБЕРCan you list the main categories of built-in data types in Python?
What tools and libraries do you use for developing solutions in the field of machine learning?
In which cases is it recommended to use key-value databases?
What are the advantages for execution speed of programs provided by the use of the async/await construct in Python?
What is the difference between programming languages that require compilation and those that are interpreted at runtime?
How can the source and cause of the problem be identified if all logs in Logstash are combined into a single stream?
How much do you cover your code with tests? How do you write tests?
What goals and tasks would you like to pursue at your new job?
How to give an AI agent a constant project context so as not to describe it again in each session?
What does the term 'linear time complexity' mean in the context of algorithms, and how does it affect performance?
How does a class using __slots__ differ from a regular class without it?
# 3. Write a simple decorator that measures the execution time of a function # 4. Given: two tables # CREATE TABLE departments ( # id SERIAL PRIMARY KEY, # name VARCHAR(100) NOT NULL # ); # CREATE TABLE employees ( # id SERIAL PRIMARY KEY, # name VARCHAR(100) NOT NULL, # department_id INT NOT NULL REFERENCES departments(id), # salary NUMERIC(10,2) NOT NULL # ); Task: # Write a query that outputs department names and their average salary, but only for departments where the average salary is higher # than the average salary across all employees in the company. Sort the result by descending average salary.
What other programming languages or technologies have you used in your projects besides Python?
ЯндексWhat is a lambda function and how does it differ from a regular function?
What are the most difficult situations you have faced when implementing or managing cache systems?
What are indexes in database management systems and what are their advantages and disadvantages?
Okko
Мой Офис
Фабрика Решения