0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software quality control experts, automation engineers, and software testers

SELECT 
    p.Id AS PostID,
    p.Title,
    p.Body,
    p.Score,
    p.ViewCount,
    p.ClosedDate,
    t.TagName,
    p.AcceptedAnswerId
FROM 
    Posts p
JOIN 
    PostTags pt ON p.Id = pt.PostId
JOIN 
    Tags t ON pt.TagId = t.Id
WHERE 
    p.ClosedDate IS NOT NULL -- Post is closed
    AND p.AcceptedAnswerId IS NOT NULL -- Post has an accepted answer (i.e., "fixed")
       AND (
        p.Title LIKE '%Activation Function%'
        OR p.Title LIKE '%Artificial Neural Network%'
        OR p.Title LIKE '%ANN%'
        OR p.Title LIKE '%Autoencoder%'
        OR p.Title LIKE '%Backpropagation%'
        OR p.Title LIKE '%Batch Normalization%'
        OR p.Title LIKE '%Convolutional Neural Network%'
        OR p.Title LIKE '%CNN%'
        OR p.Title LIKE '%Cost Function%'
        OR p.Title LIKE '%Deep Belief Network%'
        OR p.Title LIKE '%DBN%'
        OR p.Title LIKE '%Deep Learning%'
        OR p.Title LIKE '%Dropout%'
        OR p.Title LIKE '%Epoch%'
        OR p.Title LIKE '%Fully Connected Layer%'
        OR p.Title LIKE '%Generative Adversarial Network%'
        OR p.Title LIKE '%GAN%'
        OR p.Title LIKE '%Gradient Descent%'
        OR p.Title LIKE '%Hyperparameter Tuning%'
        OR p.Title LIKE '%tuning%'
        OR p.Title LIKE '%Learning Rate%'
        OR p.Title LIKE '%Long Short-Term Memory%'
        OR p.Title LIKE '%LSTM%'
        OR p.Title LIKE '%Loss Function%'
        OR p.Title LIKE '%Max Pooling%'
        OR p.Title LIKE '%Mini-Batch Gradient Descent%'
        OR p.Title LIKE '%Multilayer Perceptron%'
        OR p.Title LIKE '%MLP%'
        OR p.Title LIKE '%Neural Network%'
        OR p.Title LIKE '%Overfitting%'
        OR p.Title LIKE '%Recurrent Neural Network%'
        OR p.Title LIKE '%RNN%'
        OR p.Title LIKE '%Rectified Linear Unit%'
        OR p.Title LIKE '%ReLU%'
        OR p.Title LIKE '%Residual Network%'
        OR p.Title LIKE '%ResNet%'
        OR p.Title LIKE '%Softmax%'
        OR p.Title LIKE '%Stochastic Gradient Descent%'
        OR p.Title LIKE '%SGD%'
        OR p.Title LIKE '%Tensor%'
        OR p.Title LIKE '%Transfer Learning%'
        OR p.Title LIKE '%Vanishing Gradient Problem%'
        OR p.Title LIKE '%Weight Initialization%'
        OR p.Title LIKE '%Attention Mechanism%'
        OR p.Title LIKE '%BERT%'
        OR p.Title LIKE '%Bidirectional Encoder Representations from Transformers%'
        OR p.Title LIKE '%Capsule Network%'
        OR p.Title LIKE '%DNN%'
        OR p.Title LIKE '%Deep Neural Network%'
        OR p.Title LIKE '%Embedding%'
        OR p.Title LIKE '%Encoder-Decoder Architecture%'
        OR p.Title LIKE '%Fine-Tuning%'
        OR p.Title LIKE '%Gated Recurrent Unit%'
        OR p.Title LIKE '%GRU%'
        OR p.Title LIKE '%Gradient Clipping%'
        OR p.Title LIKE '%Graph Neural Network%'
        OR p.Title LIKE '%GNN%'
        OR p.Title LIKE '%L1 Regularization%'
        OR p.Title LIKE '%L2 Regularization%'
        OR p.Title LIKE '%Layer Normalization%'
        OR p.Title LIKE '%Leaky ReLU%'
        OR p.Title LIKE '%Learning Rate Scheduler%'
        OR p.Title LIKE '%Momentum%'
        OR p.Title LIKE '%Neural Architecture Search%'
        OR p.Title LIKE '%NAS%'
        OR p.Title LIKE '%Nesterov Accelerated Gradient%'
        OR p.Title LIKE '%NAG%'
        OR p.Title LIKE '%Normalization%'
        OR p.Title LIKE '%One-Hot Encoding%'
        OR p.Title LIKE '%Positional Encoding%'
        OR p.Title LIKE '%Pre-trained Model%'
        OR p.Title LIKE '%Reinforcement Learning%'
        OR p.Title LIKE '%Self-Attention%'
        OR p.Title LIKE '%Sequence-to-Sequence%'
        OR p.Title LIKE '%Seq2Seq%'
        OR p.Title LIKE '%Siamese Network%'
        OR p.Title LIKE '%Sigmoid Activation%'
        OR p.Title LIKE '%Spectral Normalization%'
        OR p.Title LIKE '%Sparse Coding%'
        OR p.Title LIKE '%Sparsity%'
        OR p.Title LIKE '%Stochastic Depth%'
        OR p.Title LIKE '%Support Vector Machine%'
        OR p.Title LIKE '%SVM%'
        OR p.Title LIKE '%Swish Activation%'
        OR p.Title LIKE '%Temporal Convolutional Network%'
        OR p.Title LIKE '%TCN%'
        OR p.Title LIKE '%Tokenization%'
        OR p.Title LIKE '%Transformer%'
        OR p.Title LIKE '%U-Net%'
        OR p.Title LIKE '%Upsampling%'
        OR p.Title LIKE '%Variational Autoencoder%'
        OR p.Title LIKE '%VAE%'
        OR p.Title LIKE '%Weight Decay%'
        OR p.Title LIKE '%Xavier Initialization%'
        OR p.Title LIKE '%Zero Padding%'
        OR p.Title LIKE '%AdaGrad%'
        OR p.Title LIKE '%Adam Optimizer%'
        OR p.Title LIKE '%AdamW Optimizer%'
        OR p.Title LIKE '%Adversarial Training%'
        OR p.Title LIKE '%Attention Layer%'
        OR p.Title LIKE '%Bidirectional LSTM%'
        OR p.Title LIKE '%Block Dropout%'
        OR p.Title LIKE '%Causal Convolution%'
        OR p.Title LIKE '%Char-RNN%'
        OR p.Title LIKE '%Curriculum Learning%'
        OR p.Title LIKE '%Data Augmentation%'
        OR p.Title LIKE '%Data Pipeline%'
        OR p.Title LIKE '%Denoising Autoencoder%'
        OR p.Title LIKE '%DAE%'
        OR p.Title LIKE '%Dense Layer%'
        OR p.Title LIKE '%DropConnect%'
        OR p.Title LIKE '%ELMo%'
        OR p.Title LIKE '%Embeddings from Language Models%'
        OR p.Title LIKE '%Keras%'
        OR p.Title LIKE '%Keras Layers%'
        OR p.Title LIKE '%Keras Callbacks%'
        OR p.Title LIKE '%Keras Sequential Model%'
        OR p.Title LIKE '%Keras Functional API%'
        OR p.Title LIKE '%ModelCheckpoint%'
        OR p.Title LIKE '%EarlyStopping%'
        OR p.Title LIKE '%TensorFlow%'
        OR p.Title LIKE '%TensorBoard%'
        OR p.Title LIKE '%Keras Optimizers%'
        OR p.Title LIKE '%Keras Losses%'
        OR p.Title LIKE '%Keras Metrics%'
        OR p.Title LIKE '%Keras Model Subclassing%'
        OR p.Title LIKE '%Keras Custom Layers%'
        OR p.Title LIKE '%Keras Model Compilation%'
        OR p.Title LIKE '%Keras Fit%'
        OR p.Title LIKE '%Keras Evaluate%'
        OR p.Title LIKE '%Keras Predict%'
        OR p.Title LIKE '%fit%'
        OR p.Title LIKE '%predict%'
        OR t.TagName IN (
            'Activation Function', 'Artificial Neural Network', 'ANN', 'Autoencoder', 'Backpropagation', 
            'Batch Normalization', 'Convolutional Neural Network', 'CNN', 'Cost Function', 'Deep Belief Network', 
            'DBN', 'Deep Learning', 'Dropout', 'Epoch', 'Fully Connected Layer', 'Generative Adversarial Network', 
            'GAN', 'Gradient Descent', 'Hyperparameter Tuning', 'tuning', 'Learning Rate', 'Long Short-Term Memory', 
            'LSTM', 'Loss Function', 'Max Pooling', 'Mini-Batch Gradient Descent', 'Multilayer Perceptron', 'MLP', 
            'Neural Network', 'Overfitting', 'Recurrent Neural Network', 'RNN', 'Rectified Linear Unit', 'ReLU', 
            'Residual Network', 'ResNet', 'Softmax', 'Stochastic Gradient Descent', 'SGD', 'Tensor', 
            'Transfer Learning', 'Vanishing Gradient Problem', 'Weight Initialization', 'Attention Mechanism', 
            'BERT', 'Bidirectional Encoder Representations from Transformers', 'Capsule Network', 'DNN', 
            'Deep Neural Network', 'Embedding', 'Encoder-Decoder Architecture', 'Fine-Tuning', 'Gated Recurrent Unit', 
            'GRU', 'Gradient Clipping', 'Graph Neural Network', 'GNN', 'L1 Regularization', 'L2 Regularization', 
            'Layer Normalization', 'Leaky ReLU', 'Learning Rate Scheduler', 'Momentum', 'Neural Architecture Search', 
            'NAS', 'Nesterov Accelerated Gradient', 'NAG', 'Normalization', 'One-Hot Encoding', 'Positional Encoding', 
            'Pre-trained Model', 'Reinforcement Learning', 'Self-Attention', 'Sequence-to-Sequence', 'Seq2Seq', 
            'Siamese Network', 'Sigmoid Activation', 'Spectral Normalization', 'Sparse Coding', 'Sparsity', 
            'Stochastic Depth', 'Support Vector Machine', 'SVM', 'Swish Activation', 'Temporal Convolutional Network', 
            'TCN', 'Tokenization', 'Transformer', 'U-Net', 'Upsampling', 'Variational Autoencoder', 'VAE', 
            'Weight Decay', 'Xavier Initialization', 'Zero Padding', 'AdaGrad', 'Adam Optimizer', 'AdamW Optimizer', 
            'Adversarial Training', 'Attention Layer', 'Bidirectional LSTM', 'Block Dropout', 'Causal Convolution', 
            'Char-RNN', 'Curriculum Learning', 'Data Augmentation', 'Data Pipeline', 'Denoising Autoencoder', 'DAE', 
            'Dense Layer', 'DropConnect', 'ELMo', 'Embeddings from Language Models', 'Keras', 'Keras Layers', 
            'Keras Callbacks', 'Keras Sequential Model', 'Keras Functional API', 'ModelCheckpoint', 'EarlyStopping', 
            'TensorFlow', 'TensorBoard', 'Keras Optimizers', 'Keras Losses', 'Keras Metrics', 'Keras Model Subclassing', 
            'Keras Custom Layers', 'Keras Model Compilation', 'Keras Fit', 'Keras Evaluate', 'Keras Predict', 
            'fit', 'predict'
        )
    );

fork query

edited aug 12

created jul 5 anonymous