Blog

On July 15, 2021, among the states found in the previous question, how many of them have a lower ICU bed occupation rate than that of Florida? Hint: ICU bed occupation rate equals covid_occupied_icu_beds over icu_beds 

Which is the correct statement to create an index to fast look up a tweet by publishing time?

From January to June 2021 (inclusive), find the US states whose accumulated number of fully vaccinations is higher than the accumulated number of first dose vaccinations in Florida. Your answer should be sorted by the accumulated number of fully vaccinations in those states in descending order. Hint: the accumulated number only includes those occurred within that time window. No need to consider those occurred before the time window.

Quiz part 1 Suppose you have a twitter database, given the schema (underlined attributes are primary keys):  UserInfo(userID, username, displayName, location, joinDatetime)UserGraph(userID, followerID)Tweet(tweetID, userID, publishTime, tweet) The database tables have the following semantics:1. UserInfo contains user information, including ID of the user, username, displayed name, user location, and the date and time when the user joined twitter.2. UserGraph contains the directed edges from twitter users to their followers.3. Tweet contains all the tweets every user has published, including ID of the tweet, ID of the user, publishing time and the tweet text. Answer the Question 1 and 2 based on this database.

Pareto’s principle is as it pertains to warehouse operations, says ___ .

What is an ERP system?

When comparing Metric vs Imperial units, which of the following are true? Multiple answer

What is an advantage of usin cloud storage for supply chain data?

To increase the vault of a soft contact lens you could select a:

 The pre-corneal tear film is composed of three distinct layers they are: