1. Load the tidyverse package first and then explore the diamonds dataset. What’s the average price of premium cut diamonds in the diamonds dataset?

Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task   Retrieve the mailing address (first name, surname, and address) for each resident.   Task 7: The development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT.     Alter the RESIDENTS table and change the ID field to an auto-incremented field. Task 8: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table. Task   Add Yigit…

Hi, the data that is populating the Supplier Field is from this string object in bold that is one of this variable parameters:  var supplierField = form.addField('custpage_supplier', 'select', 'Supplier', 'customrecord_reorder_suppliers').setLayoutType('startrow');   How do I go about retrieving the suppliers name and reordering the name view from this internal ID 'customrecord_reorder_suppliers'. This ID/string object is to a custom table in NetSuite that houses the supplier information. *Please see screenshot of suppliers table*   I have tried: var supplierName = 'customrecord_reorder_suppliers'.toString().split(' ').reverse().join(' ');. To reassign that string object so I could call it in a function but it still did not work.    If needed we can get on a chat to discuss this in more detail. Please let me know.

Read the data into a DataFrame with ID as the index. Convert the “Hired” column into Date/Time data type Create a new column with years of experience with the company at present without rounding. Create a new Boolean column for senior status with employees with at least 10 years of experience as senior and others are not. Create a new column for longevity pay equal to $150 per whole year of experience in the company. Create a list of column names for each data type in the DataFrtame.

Data on the age of 11 residents who live in a house are as follows: 2,4, 4, 5, 7, 9, 11, 11, 13, 14, 41. Please determine the value and describe the positions of Q1, Q2, Q3,Minimum, Maximum, and Outlier of the dataset mentioned above. Please also specify the value andnew Minimum data position; New Maximum Data, as well as a mustache. In doing analysisnext, what will you do with the outlier??? Explain the reasonSibling.

is there any other way to do it without changing the create table instances and just do everything under this part? SELECT * FROM "arena"WHERE "people_count" >=100ORDER By "event_date" ASC

The InstantRide Driver Relationship team wants to learn how many travels each driver has done in the month of October. You need to send them the DRIVER_ID, and two calculated columns: DAY and RIDES. The DAY column is calculated using the DAY() function with the TRAVEL_START_TIME as the argument. The RIDES column is calculated by using the COUNT() function to determine the number of rides given for each day. Filter the results with the MONTH function.