Question: in Rstudio The database models the business 'Tiny Clothes'. Read the Database Description (posted on GS) NOTE: Each time you open your RStudio database script,
in Rstudio
The database models the business 'Tiny Clothes'. Read the Database Description (posted on GS) NOTE: Each time you open your RStudio database script, you need to run the dbConnect statement. This makes sure you are connected to the correct database. Write and submit RSQLite queries to answer the following questions and queries about 'Tiny Clothes'. Return only the specified attributes and tuples. 1. Find the employee number and age of all employees whose age is less than 50. 2. Find the names of all the employees at 'Tiny Clothes'. (Return names only) 3. Retrieve all the distinct employee names of employees at 'Tiny Clothes' 4. Find all the employee names that begin with the letter 'B'. 5. Retrieve the names and NI numbers (NI_NO) of all employees. 6. Retrieve details of employees who are between 31 years of age and 65 years of age inclusive. Return only the specified attributes and tuples. Add a comment with the answer. 7. Have all departments been assigned a manager? 8. On what date did customer C3 place their order? 9. Which products are available in white? 10. Which office does employee E2 occupy
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
