回复DELOITTE ON-CAMPUS EXAM✅✅
Contact : @MLCODER2
照片
点击显示
点击显示
INSTANT RESULTS FOR DELOITTE✅
NEXT: PEARSON ENGLISH ASSESSMENT✅
743 · def count_vowel_substring(input1):
#write your code here
v=set("aeiou")
c=0
i=0
while i<len(input1):
if input1[i] in v:
j=i+1
while j<len(input1) and input1[j] not in v:
j+=1
if j<len(input1):
c+=1
i=j+1
else:
break
else:
i+=1
return c
Accenture✅
682 · SELECT
c.customer_id,
CONCAT(c.first_name, ' ', c.last_name) AS full_name,
COUNT(r.rental_id) AS rental_count
FROM customer c
JOIN rental r
ON c.customer_id = r.customer_id
GROUP BY c.customer_id, c.first_name, c.last_name
HAVING COUNT(r.rental_id) > 2
ORDER BY c.customer_id ASC;
SQL✅
//Accenture
756 · 照片
点击显示
779 · 点击显示