Tutor profile: Akhilesh C.
Questions
Subject: SQL Programming
Select the Ids where the Pressureon a given day is lesser than the pressure yesterday +---------+------------------+------------------+ | Id(INT) | RecordDate(DATE) | Pressure(INT) | +---------+------------------+------------------+ | 1 | 2021-01-01 | 1000 | | 2 | 2021-01-02 | 1100 | | 3 | 2021-01-03 | 1050 | | 4 | 2021-01-04 | 950 | +---------+------------------+------------------+
SELECT DISTINCT a.Id FROM Weather a, Weather b WHERE a.pressure < b.pressure AND DATEDIFF(a.Recorddate, b.Recorddate) = 1
Subject: R Programming
Lazy Evaluation of Function Answer [1] 49 [1] 7 Error in print(b) : argument "b" is missing, with no default
# Create a function with arguments. lazy <- function(a, b) { print(a^2) print(a) print(b) } # Evaluate the function without supplying one of the arguments. lazy(7)
Subject: Python Programming
Print the character the first character which has only occurred one's in String. the character are case insensitive Ex: KeepingTruckIN Answer is p
test_str = "KeepingTruckIN" test_str = test_str.lower() # using naive method to get count # of each element in string all_freq = {} for i in test_str: if i in all_freq: all_freq[i] += 1 else: all_freq[i] = 1 list2=[] for i,j in all_freq.items(): if j==1: list2.append(i) print(list2[0])
Contact tutor
needs and Akhilesh will reply soon.