Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
superqueries_Steve
consulta:- read(X), arbol(X),write(';'). arbol(A):- read(X), (X='tabla'->tabla(A);write("")). tabla(A):- read(T), read(X), (X='tabla'->a2(A,T);(X='fin'->a1(A, T); write(""))). a1(A, T):- write("select "), write(T), write(", count(*)/(select count(*) from "), write(A), write(") as probabilidad from "), write(A), write(" where "), write(T), write(" in(select distinct "), write(T), write(" from "), write(A), write(") group by "), write(T). a2(A, T1):- read(T2), write("select "), write(T1), write(", "), write(T2), write(", count(*)/(select count(*) from "), write(A), write(") as Probabilidad from "), write(A), write(" where "), write(T1), write(" in(select distinct "), write(T1), write(" from "), write(A), write(") and "), write(T2), write(" in(select distinct "), write(T2), write(" from "), write(A), write(") "), write("group by "), write(T2), write(", "), write(T1), write(" order by "), write(T1), write(", "), write(T2). :-consulta.
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Martinez Garcia Edson Vadir 2
Programa de Arrays
completar el estandar del objeto empresa con datos aleatorios
Tarea
Tarea 27/08/2021
a
ISAN_VELIZ_ESTRADA_ERICK_RODRIGO
Tarea 27/08/2021 Arredondo Amaro Carlos Jair
probabilidad de los valores de un campo 3 sep
Ejercicio gramática - González Reyes Gabriel
Please log in to post a comment.